Failure when posting new ad
 

I just installed Classifieds 2.42 with vBulletin 3.5. The installation went fine, and everything seems to be configured okay. However, when I try to Place an Ad, I receive the error:

Database error! Please report to System Administrator.

INSERT INTO pp_products (id,user,userid,cat,date,title,description,keywords,bigimage,bigimage2,bigimage3,approved,watermarked,ipaddress) values(NULL,'michael', 2, 8, , 'stuff', 'give me stuff', '', '', '', '', 1, '', '24.4.37.183')

I ran the query manually against the database and received:

#1064 - 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 ' 'stuff', 'give me stuff', '', '', '', '', 1, '', '24.4.37.183')' at line 1

Here's my specs:
PHP 5.1.1
MySQL 4.1.15

Any help is appreciated.
Thanks,
Michael West
michael@vfrworld.com

Hi Chuck! I know it's Christmas Eve and all, and hopefully you're not working on a holiday, but just curious if you've read my post and have any ideas for me? My site is just about ready to launch, this is one of the last issues I need to resolve.

Thanks!
Michael

Okay I posted this in another forum but basically PHP 5.1X series has an issue with localtime();

Basically in all our scripts where you find this

$mon = $mon + 1;

this needs be added beneath

$year = $year + 1900;

Thanks Chuck, it works perfectly now!

What scripts is this code in? I cant find it..

Found it, thanks