Exclusive eBooks, Software Solutions, Quality Guaranteed
 
Web NukeBiz
Welcome to NukeBiz · Members
Amazon
show cart or checkout0 items
Cart Value: 0.00

Forums » DragonflyCMS Projects » MReviews » Unknown column author_user in field list
Unknown column author_user in field list
A system for categorizing and managing reviews.
Topic initiation via Bugger.

Post new topic    Reply to topic    Printer Friendly Page     Forum Index »  Community » MReviews

View previous topic :: View next topic  
Author Message
Keeper
Guest





PostPosted: Tue May 24, 2005 10:20 pm
Post subject: Unknown column author_user in field list

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:

[code]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[/code]

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
Back to top
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Thu May 26, 2005 10:58 am
Post subject: Re: Unknown column author_user in field list

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.


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
Keeper
Guest





PostPosted: Fri May 27, 2005 10:52 pm
Post subject: Re: Unknown column author_user in field list

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
Back to top
Keeper
Guest





PostPosted: Fri May 27, 2005 10:56 pm
Post subject: Re: Unknown column author_user in field list

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
Back to top
Keeper
Guest





PostPosted: Fri May 27, 2005 11:06 pm
Post subject: Re: Unknown column author_user in field list

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


Back to top
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Sat May 28, 2005 3:08 am
Post subject: Re: Unknown column author_user in field list

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.


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Tue May 31, 2005 8:11 am
Post subject: Re: Unknown column author_user in field list

Issue fixed in v9.0.0.5 now released.


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
Keeper
Guest





PostPosted: Tue May 31, 2005 7:12 pm
Post subject: Re: Unknown column author_user in field list

Thank you!!!
Back to top
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Tue May 31, 2005 7:16 pm
Post subject: Re: Unknown column author_user in field list

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


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
Display posts from previous:   
Post new topic    Reply to topic    Printer Friendly Page    Forum Index »  Community » MReviews
Page 1 of 1
All times are GMT + 9.5 Hours



Jump to:  


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum