DragonflyCMS Projects > MReviews > Unknown column author_user in field list > Community Forums > Phoenix Netology
Forum Index > Community > MReviews

Unknown column author_user in field list Reply to topic


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

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.

Thank you;
John Briggs

Something else I forgot to add, the date of the review shows as:

Added: December 31st 1969


when you view the review.

Thanks again for this great module. I'll be patient while you work on it.

John Briggs

I may not be explaining this very well, so here is a screen shot:



hmm, looks like I didn't finish the admin pending bit after adding the extra image, which is why it's all displaced.

No time now, so I've restored the 9.0.0.4 download.

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


Issue fixed in v9.0.0.5 now released.

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


Thank you!!!

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 Embarassed

The stupid and unforgiveable part was that I had failed to check my work Sad

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

All times are Australia/Adelaide


Jump to: