Did some more research; I do not find any of the 18 "RCS_..." configuration keys in my configuration table; maybe I am looking in the wrong place?.
The "'Recover Cart Sales' " shows up OK in the configuration_group table.
Printable View
Did some more research; I do not find any of the 18 "RCS_..." configuration keys in my configuration table; maybe I am looking in the wrong place?.
The "'Recover Cart Sales' " shows up OK in the configuration_group table.
Attachment 13101
The SQL is definitely not updating the configuration table.
See attachment, I sorted the configuration keys alphabetically & nothing starting RCS shows up.
The SQL code looks OK to me; not that I know much :)
Could it be a permission thing?
I tried just running the piece of SQL starting with "INSERT INTO configuration (configuration_id.......)
Seemed to run OK but did not update the table.
Help!!
Try deleting the configuration_group table entry (or entries?) associated with the name "Recover Cart Sales", make sure that there are no items in the configuration table that start with RCS_ and then re-run the SQL that I posted.
Tried that but did not work. :(
I found this tip in the zen cart wiki (see below) & now the configuration table is updated & RCS works (mostly) still cannot "configure" but Tool & Reports are OK. :unsure:
Tip
"Sometimes the patch tool will give you this error:
ERROR: Cannot insert configuration_key "" because it already exists
This may be related to particular versions of PHP, MySQL, and phpMyAdmin, or it may not. If you get this error, you can just run the SQL file directly in phpMyAdmin. "
I have v1.5.1 and and doing a new install; I could only get the upgrade-ZC-v-1-5.sql file to upload. When I tried the install-ZC-v-1-5.sql through Tools> Install SQL Patches it fails and says, Warning: An Error occurred,please refresh the page and try again. But since I got positive confirmation that the "upgrade" file took, I uploaded the files to my admin folder. I'm not sure if this is how it is designed to work, but that's what I did.
Now, I have all the RCS menus displaying in Admin. But, even after adding products to my cart and logging off, I don't see anything in the reports. However, I do get an error that says: Warning: Ad Error occurred, please refresh the page and try again.
Attachment 13235
I've double checked my admin folders and everything is uploaded correctly. I suspect it's related to the database, but I have no idea where to start. Any ideas?
Thanks in advance.
Seems that this is the offending script:
CREATE TABLE scart (
scartid int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
dateadded varchar(8) NOT NULL default '',
datemodified varchar(8) NOT NULL default '',
PRIMARY KEY (scartid),
UNIQUE KEY customers_id (customers_id),
UNIQUE KEY scartid (scartid)
) TYPE=MyISAM;
I removed the TYPE=MyISAM from the script and it appears to be working now.
Is TYPE=MyISAM critical? What does it do that might mess something else up?
Okay, I sent a test e-mail to myself, but I didn't get it.
Also, I was earlier able to change RCS configurations but now it's a blank page.
I just installed this and I'm having the exact problem. The 'upgrade' file worked but I'm getting an error in the admin menus. Help would be greatly appreciated.Quote:
Originally Posted by Infidel
Neo
I am receiving both error messages:
WARNING: An Error occurred, please refresh the page and try again.
and
#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 'TYPE=MyISAM' at line 9
This seems like an important mod but I just cannot seem to get it to work with 1.5.1