To begin with, thank you for this wonderful module!
All went well when I installed the module on my site. Set everything up fine, made categories and sub-categories.
I logged on to test it by writing a review, after writing the review, previewing it, and then submitting it, it says there was a problem and admin has been notified.
Here is what I received in my admins email:
On /MReviews.html
While executing query "INSERT INTO cms_MReviews_pend( date, pagename, content, cid, scid, author, author_email, author_user, author_ip, r_link, r_link_title, score)
VALUES (now(), 'Lighthouse Depot', 'Everything and anything lighthouse related can be purchased on this website.\r\n\r\nFor the collector, there is an extensive line of Harbour Lights replicas of lighthouses from across the world.\r\n\r\nSome of the many items include, dinnerware, kitchenware, curtains, towels, tables, chairs... just to many to list.\r\nYou may request a catalog on this website, or browse their online store. \r\n\r\nFor the ultimate shopping experience, visit the Lighthouse Depot when traveling in the northeast. The business is located in Wells, Maine and a lighthouse museum is next door.', '3', '7', 'Keeper', 'admin@lighthousegazette.com', '1', '24.131.147.145', 'http://www.lighthousedepot.com/', 'Lighthouse Depot', '10')"
the following error occured: Unknown column 'author_user' in 'field list'
In: /home/keeper/public_html/modules/MReviews/index.php on line: 411
Guest information:
User id: 2
Username: Keeper
Admin: No
IP: 24.131.147.145
Host: c-24-131-147-145.hsd1.ma.comcast.net
I have no idea what is wrong and wonder if you could help me please. If anymore info is needed, please let me know.
Thank you;
John Briggs
PhoenixOffline
Joined: Mar 18, 2004
Posts: 1543
Location: Netosphere
This is the result of a stupid oversight on my part for new installations - I have omitted 2 fields which I added to the MReviews_pend table.
I shall fix in the download, but if you are comfortable with using phpmyadmin you can fix your existing database as follows,
1. BACKUP your datbase
2. run these 2 sql queries,
ALTER TABLE `cms_MReviews_pend` ADD `author_user` TINYINT( 1 ) DEFAULT '1' NOT NULL AFTER `author_email` ;
ALTER TABLE `cms_MReviews_pend` ADD `author_ip` VARCHAR( 15 ) DEFAULT '0' NOT NULL AFTER `author_user` ;
My apologies for the error and for not seeing your post sooner.
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
That you for the fix, it is greatly appreciated! It now works, but in admin, when I go to approve the review, the "content" is in the "link title" box, the "link title" is in the "image file name" box and the "reviewer email" is in the "related link" box. The "score" is missing and none of the categories selected during writing of the review show up.
Since I wrote the review, I fixed the content and other items, but if someone else writes a review, I will have no idea what is going on. If anymore info needed, please let me know.
np - turns out I had done the admin interface, but had taken a shortcut and copied a line of code from another part of the file - unfortunately, that line had the variables in the wrong order
The stupid and unforgiveable part was that I had failed to check my work
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
