PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > PhotoPost Classifieds Support > Classifieds Bug Reports

Classifieds Bug Reports Post any problems you may be having with Classifieds here.

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old December 5th, 2004, 02:14 AM   #1 (permalink)
Registered User
 
Join Date: May 2002
Posts: 33
MySQL error during install 2.0

Hi, I just did a fresh install of Classifieds 2.0 and got the error below!
Please help!
------------------------------------------

MySQL error reported!

Script: install

Query: INSERT INTO pp_usergroups (groupid,groupname,modaccess,cpaccess,uploads,comments,editpho,editposts,reqmod,highlight,bold,italic) VALUES('1','Administrators','0','1','0','0','','0','0','0', 0, 0, 0)

Result: Column count doesn't match value count at row 1

Database handle: Resource id #11
Matthijs is offline   Reply With Quote
Old December 6th, 2004, 11:21 AM   #2 (permalink)
PhotoPost Developer
Verified Customer
 
Join Date: Jan 2002
Posts: 11,858
What integration are you using? I can't find that query.

Note: Oh, wait, Threads?

in forums/threads.php, lines 431 has an extra variable in it:

'$uploadsize',

remove that from line 431 in forums/threads.php:

Code:
Content visible to verified customers only.
__________________
Please do not PM me for support or sales questions. Thank you for your understanding.
Michael P is offline   Reply With Quote
Old December 6th, 2004, 02:54 PM   #3 (permalink)
Registered User
 
Join Date: May 2002
Posts: 33
Thanks, that solved the problem!

p.s. I found another small bug: the zipData table is created without prefix!

thanks,
matthijs
Matthijs is offline   Reply With Quote
Old December 6th, 2004, 03:04 PM   #4 (permalink)
PhotoPost Developer
Verified Customer
 
Join Date: Jan 2002
Posts: 11,858
It's not suppose to have one.
__________________
Please do not PM me for support or sales questions. Thank you for your understanding.
Michael P is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2.9vb3 - install -not a valid MySQL-Link rastacat ReviewPost Installation & Upgrades 4 October 21st, 2005 09:46 AM
4.8.1: MySQL Error on Step 3 of Install Muhammad Photopost Pro Installation & Upgrades 3 August 2nd, 2004 01:04 PM
Fresh Install 4.8d + Threads .6x and MySQL Error Keet Photopost Pro Installation & Upgrades 4 July 18th, 2004 08:44 PM
MySQL Error on new install djroketboy Classifieds Installation & Upgrades 7 June 22nd, 2004 11:21 AM


All times are GMT -5. The time now is 06:19 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0