Home
Screenshots
Downloads
Demo
Support
Forums
Home
Help
Search
Quick Search
Advanced Search
[Close]
Login
Register
Welcome Guest, please
login
or
register
.
Username:
1 Hour
1 Day
1 Week
1 Month
Forever
Password:
News
: Development has begun on 3.0.0. See the the announcement in the Core Development Forum for details!
Development has begun on 3.0.0. See the the announcement in the Core Development Forum for details!
Help Center Live Community
Support
Installation Help & Software Support
(Moderator:
Monty
)
sql error
Pages: [
1
]
Go Down
Topic Tools
Topic Tools
Print
January 14, 2008, 04:59:28 PM
kevinvanw
Not too much to say...
Offline
Posts: 4
sql 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 'picture`=" " WHERE `id`="1"' at line 1
UPDATE `hcl_operators` SET `firstname`="Default", `lastname`="User", `email`="
admin@example.com
", `autosave`="1", `showpic`="1" `picture`=" " WHERE `id`="1"
how do i solve this? im using v.5
Logged
January 16, 2008, 06:21:34 PM
victor
HCL Member
Offline
Posts: 266
Re: sql error
check your username, password and username permissions to update th database
Logged
Victor Pereyra
July 18, 2008, 10:57:50 AM
Gigo
Not too much to say...
Offline
Posts: 2
Re: sql error
Nop. I have problem too. Problem is in SQL syntax. Missing comma in SQL syntax before picture.
Syntax is
Code:
UPDATE `hcl_operators` SET `firstname`="Default", `lastname`="User", `email`="admin@example.com", `autosave`="1", `showpic`="1" `picture`=" " WHERE `id`="1"
instead
Code:
UPDATE `hcl_operators` SET `firstname`="Default", `lastname`="User", `email`="admin@example.com", `autosave`="1", `showpic`="1", `picture`=" " WHERE `id`="1"
Logged
July 31, 2008, 12:13:06 PM
sitiseo
Not too much to say...
Offline
Posts: 2
Re: sql error
I have the same problem . . .
Help please . . .
Thank's
Edit: Ok, I resolved, not wrote the password
«
Last Edit: July 31, 2008, 05:10:34 PM by sitiseo
»
Logged
August 26, 2008, 02:54:24 PM
surG
Not too much to say...
Offline
Posts: 4
Re: sql error
kevinvanw May be i'm too late to reply. . but i guess it'll help you (or anybody that's stuck in this problem )
hxxp: www. helpcenterlive. com/smf/mysql_syntax_error_in_downloaded_code-t321. 0. html
This post says. . .
Quote from: quakerc
There is a small error, a missing comma, in line 286 of . . . /class/operator. php which is enough to cause MySQL to fail when trying to update operator details. The comma should come between the showpic item and the picture item.
It's simple to fix if you have access to the code but this is not always the case with users who are using code installed by a hosting company for them.
QuakerC :)
Logged
Pages: [
1
]
Go Up
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General
-----------------------------
=> Announcements
=> General Discussion
=> Web Site Discussion
-----------------------------
Support
-----------------------------
=> Installation Help & Software Support
=> Paid installation board
=> Daily Operations
=> Tips and Tricks
=> Unofficial WinApp Support
-----------------------------
Development
-----------------------------
=> Core System Development
===> Bug Discussions
===> New Feature Discussion
===> Feature Requests
=> Module Development
===> Module Requests
===> eTicket
=> Themes
Loading...
Print