Archive
Million Dolar with PHP5 and MySQL commuity edition
Started July 3, 2009 by steverifkin
Hello, I have the script up and working, but there is some strange behavior in the php outpurt. For instance, when i execute php just spits out the constant SITE_LOGO_URL in the source. I don't understand. I have checked the constant and it is correct. And while I'm on the topic, I noticed the same type of error when adding a new field to the ad form. The field type doesn't matter. I am getting the error: 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 ' ADD 4 VARCHAR( 255 ) NOT NULL' at line 1 'ADD' 4 is speaking of the record being inserted after submitting form2 and calling the add_field_if_init(). I think this has to do with the version of PHP and SQL that this script has been tested on. Can anyone give me suggestion as to what I can change in the php.ini file that will make the SQL error pass? My host is running PHP 5.2.9 and MySQL 5.1.30 and I can get php_info() if needed.
2 replies
Just wanted to add a little more information from the host with specifics on the apache version and runtime info for sql and php: Server version: Apache/2.2.11 (Unix) Cpanel::Easy::Apache v3.2.0 rev4654 Server version: 5.1.30 MySQL Community Server (GPL) PHP 5.2.8 (cli) (built: Mar 31 2009 03:45:34) Copyright (c) 1997-2008 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies with the ionCube PHP Loader v3.1.34, Copyright (c) 2002-2009, by ionCube Ltd., and with Zend Extension Manager v1.2.2, Copyright (c) 2003-2007, by Zend Technologies with Zend Optimizer v3.3.3, Copyright (c) 1998-2007, by Zend Technologies Thanks for any insight.
im have the same issue i can not create a NEW FIELD on the AD form i get the same ERROR message then it causes the system to get jam were i can even go back and click AD FORM to undo what i just did. I have to go into the database and remove it manually that route. I wish some can help us on this. Can you get the IMAGE on the AD form to work. You know the ad form came DEFAULT with the 3 fields. the TEXT the URL and then the IMAGE. i cannt even get the image to work. When tested from a user point of view placing a test order on my site. when i uploaded my image that i wanted to display in the POP UP box i get a error about uploaded_files is not a directory or something. I have no idea what to do. I have all permissions set as they should 777 or as directed