Archived > Install error

MySQL Error while executing:
INSERT INTO cms_MReviews_cats VALUES (1, 'MReviews', 'Any info that doesn't fit the following categories on the MReviews module can go here.', 'modules/MReviews/admin/MReviews.gif', 1)

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 't fit the following categories on the MReviews module can go he

what does this mean? my prefix isn't cms...its nuke

These lines need the apostrophe escaped. (doesn\'t)
See below:

$queries[] = "INSERT INTO ".$prefix."_MReviews_cats VALUES (1, 'MReviews', 'Any info that does\'t fit the following categories on the MReviews module can go here.', 'modules/MReviews/admin/MReviews.gif', 1)";
$queries[] = "INSERT INTO ".$prefix."_MReviews_cats VALUES (2, 'FriendFinder', 'Any info that doesn\'t fit the following categories on the FriendFinder module can go here.', 'modules/MReviews/admin/MReviews.gif', 1)";
$queries[] = "INSERT INTO ".$prefix."_MReviews_cats VALUES (3, 'IP Tracker', 'Any info that doesn\'t fit the following categories on IP Tracker can go here.', 'images/admin/MReviews.gif', 1)";

hmm, a pretty stupid mistake with the apostrophe - sorry about that - haste makes waste

I will fix the download.

The prefix 'cms' is not from the module - you may have updated your site recently.

thanks, nm the cms thing i thought i was on my old site :oops: works perfect now

glad to hear - anyway, it forced me to do another thorough check - after the apostrophe screwup, I didn't want any more issues

Mind you, there are a couple of sql table keys that I noticed are incorrect, but can be fixed later.