Return to iWEBTOOL

Go Back   iWEBTOOL Talk > The Web and your Website > Programming
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
 
Welcome to iWEBTOOL Talk, where you talk about webmaster-related stuff.
 
Discuss topics which interest you.
With over thousands of threads (topics), we're sure you'll find something that'll interest you.
Ask for help whenever you need it.
We have thousands of members who are available to help you if you need it.
It's absolutely FREE!

 1  Register           2  Browse the board           3  Discuss whatever may interest you!
 


Closed Thread
 
Thread Tools Search this Thread Display Modes
Old 07-31-2007, 11:41 PM   #1
davinbourne33
Newcomer
 
davinbourne33's Avatar
 
Join Date: Jul 2007
Posts: 1
davinbourne33 is on a distinguished road
Default SQL syntax error posting to http://london.photo-ads.co.uk

Recently I have been unable to post an advertisement in http://london.photo-ads.co.uk.

I originally posted an advert in this directory without any problems in December 2006.

What is amazing is that I can post to birmingham.photo-ads (http://birmingham.photo-ads.co.uk) but not london.photo-ads which uses the same database.

Because other users apparently do not seem to have the same trouble posting to london.photo-ads is probably the reason that I have not been able to get any response from the site moderator.
(day by day posts are being added)

This is the problem........

To post an ad in http://london.photo-ads.co.uk you have to register and then log in.
You are then directed to "Edit User Profile" .....

Quote:
Your email:

Display a link on my profile to allow people to email me

Change password:

Repeat password:

User name:

First name:

Last name:

Postcode:

Homepage:

About you:

When you submit this screen an error is produced and the details have not been updated although it says they have. At this point you cannot proceed any further ........

Quote:
Notice: Query failed: 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 '' at line 4 SQL: UPDATE site_users SET display = 0, fname= '', lname= '', postcode= '', homepage= '', about= '', show_link_profile= 0, valid= 0 WHERE users_id= in /home/photoads/public_html/site/include/functions/class.mysql.php on line 54

Note: For the purpose of copying the code I have not completed any of the fields. That is why there are no entries showing in the error code. It does not make any difference what goes in the fields anyway because it still gives the same error message which says " .... right syntax to use near '' at line 4".

The obvious conclusion is that the site owner's php SQL is at fault, but if that was the case then other users would be experiencing the same problem and would not be able to post to london.photo-ads, but they can!

When I click to "post an ad" in the Birmingham directory it asks you to log in and then it directs you to the page to post an ad, but doing the same thing in the London directory it takes you to "Edit User Profile" which cannot be saved because of this syntax error.
The message says the account has been updated (although it hasn't) and then asks you log in to post your ad (back to square one again).

I have tried disabling lots of things on my computer like HOSTS / Norton Internet Security / Ad Blockers.

I have also tried posting in different Browsers .... Firefox / IE7 / Opera.

I am not very technical when it comes to syntax errors, SQL, php code and the like.

Do you have any ideas on how to overcome this rather unusual problem?
davinbourne33 is offline  
 
This is an Ad Revenue Sharing forum Place your advert here
SEO Checklist
Get yourself better ranking with
our "Do-it-Yourself" SEO Checklist.
Click Here
Closed Thread

(Threads which have no activity for more than 30 days are automatically closed.)



Quick Reply
Message:

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
London UK Business Directory XantosNew Your directory 0 03-28-2007 02:22 PM
Hello from London! dhscott Introduce yourself 3 02-17-2007 07:11 PM
ideal posting. Paid Forum Posting Service. mmelen Other Goods 6 10-02-2006 06:59 AM
Hello from London Uk BUSSA Introduce yourself 5 07-27-2006 08:48 PM
Hi from London peterW Introduce yourself 4 03-25-2006 09:25 PM


All times are GMT. The time now is 08:41 PM.


Powered by vBulletin v3.6.7 © 2008, Jelsoft Enterprises Ltd. SEO by vBSEO © 2006, Crawlability, Inc.