DragonflyCMS Projects > MReviews :: Archives > Install error :: Archived > Community Forums > Phoenix Netology
Forum Index > Community > MReviews > Archives

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

Please enter your server specs in your user profile! 😢


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)";

Please enter your server specs in your user profile! 😢


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

I will fix the download.

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

Donations & Audit for DragonflyCMS

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


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

Please enter your server specs in your user profile! 😢


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

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

Donations & Audit for DragonflyCMS

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):

All times are Australia/Adelaide