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 Installation & Upgrades

Classifieds Installation & Upgrades If you're having install or upgrade problems, post here.

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old December 21st, 2005, 02:04 AM   #1 (permalink)
Member
Verified Customer
 
Join Date: Apr 2005
Posts: 56
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
volarium is offline   Reply With Quote
Old December 24th, 2005, 04:01 PM   #2 (permalink)
Member
Verified Customer
 
Join Date: Apr 2005
Posts: 56
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
volarium is offline   Reply With Quote
Old December 24th, 2005, 05:05 PM   #3 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,692
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;
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old December 24th, 2005, 05:42 PM   #4 (permalink)
Member
Verified Customer
 
Join Date: Apr 2005
Posts: 56
Thanks Chuck, it works perfectly now!
volarium is offline   Reply With Quote
Old January 2nd, 2006, 01:25 AM   #5 (permalink)
Member
Verified Customer
 
Join Date: Dec 2005
Posts: 37
What scripts is this code in? I cant find it..
LLIFE is offline   Reply With Quote
Old January 2nd, 2006, 03:55 AM   #6 (permalink)
Member
Verified Customer
 
Join Date: Dec 2005
Posts: 37
Found it, thanks
LLIFE 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
Fee for posting an Ad tbone2 Classifieds How do I...? 1 December 17th, 2005 08:25 AM
Photoshop Triggered mysql failure pengrus General Discussion 3 November 14th, 2005 03:34 AM
posting pictures sitka Photopost Pro How Do I...? 10 March 9th, 2005 09:45 PM
4.8.1: Failure on uploading video South Fork Photopost Pro Installation & Upgrades 12 November 30th, 2004 10:09 AM


All times are GMT -5. The time now is 11:27 AM.

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