New Zenner
- Join Date:
- Dec 2006
- Posts:
- 71
- Plugin Contributions:
- 0
New Zenner
New Zenner
Sensei
No idea.
Perhaps your database didn't install properly?
Perhaps your table-prefixes didn't build correctly?
The way the code is written, that should never happen ... and I've never seen it happen before.
Were there any warnings/errors that you chose to ignore on the System Inspection page?
What are your system/server's specifications?
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
New Zenner
New Zenner
Sensei
What is the URL to your zc_install/techsupp.php ?
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
New Zenner
Hey DrByte,
I have run afoul of the same database patch issue, albeit with afresh install of 1.3.7 after importing my database from 1.3.5. Here's the error:
Your database appears to need patching to a higher level. See Tools->Server Information to review patch levels.
The error shows up at the top of the page of both the shop and the admin.
When going to the Tools->Server Information page, I don't know what information I am looking for or what further steps to take to address the issue.
I have attached a zipped PDF of my zc_install/techsupp.php.
All help greatly appreciated.
Regards,
Mark Harrison
New Zenner
Hi guys,
Still unsuccessful in "patching" database or otherwise removing the bright red warning quoted above. On the cusp of taking the site live, but need to remove this warning before going further. The warning wasn't there when the database was empty. Only after populating the table with the 1.3.5 data.
All help appreciated. You can see the store here: http://bender.liquidweb.com/~limoleds/zc1370/
Thanks in advance,
Mark Harrison
Obaa-san
Upgrade the database.
Please do not PM for support issues: a private solution doesn't benefit the community.
Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.
New Zenner
Hi Kim,
Thanks for the tip. I also found this forum thread helpful: http://www.zen-cart.com/forum/showthread.php?t=50389&highlight=patch+levels
What I figured out was that I did a clean install of 1.3.7 and then added my 1.3.5 backup data to my new empty 1.3.7 database after this step. This is when the patch level warnings appeared. I also found this to be true at my remotely hosted site (Linux) as well as my local development site (Macintosh). Thus, I don't believe this to be an Linux specific issue.
The key on both of my sites was to simply re-run the Zen Cart installer in order to have the database upgraded. Once this was done, all warnings disappeared.
Thanks again. Hoping to go live within 48 hours.
Regards,
Mark Harrison
New Zenner
Hi folks,
Wanted to report that I got the following error when backing up my remote site with PHPmyadmin and then using the admin to restore to my local site:
1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '0'', ''1''),'');')' at line 1
in:
[INSERT INTO upgrade_exceptions (upgrade_exception_id, sql_file, reason, errordate, sqlstatement) VALUES (1, 'sql/mysql_upgrade_zencart_135_to_136.sql', 'Cannot ADD column get_term_table because it already exists.', '2007-01-08 17:50:58', 'ALTER TABLE get_terms_to_filter ADD get_term_table varchar(64) NOT NULL;'), (2, 'sql/mysql_upgrade_zencart_135_to_136.sql', 'Cannot ADD column get_term_name_field because it already exists.', '2007-01-08 17:50:58', 'ALTER TABLE get_terms_to_filter ADD get_term_name_field varchar(64) NOT NULL;'), (3, 'sql/mysql_upgrade_zencart_136_to_137.sql', 'Cannot insert configuration_key "DEFINE_PAGE_NOT_FOUND_STATUS" because it already exists', '2007-01-08 17:50:59', 'INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values (''Define Page-Not-Found Status'', ''DEFINE_PAGE_NOT_FOUND_STATUS'', ''1'', ''Enable the Defined Page-Not-Found Text from define-pages?
0= Define Text OFF
1= Define Text ON'', ''25'', ''67'', now(), now(), NULL, ''zen_cfg_select_option(array(''0'', ''1''),'');');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
This looks a lot like the "skipped" text listed on the Upgrade Database page when I worked through that step. (See previous post.) Despite this error, the restore looks to have completed as I have verified that changes made to the first site are now present on the second site.
I guess maybe this should be recorded as a "benign" bug? IF I am missing something more here, please advise.
Regards,
Mark Harrison
Tell staff why this post should be reviewed.