Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offday
Today is our off day. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Sunday 11:17 pm
Add a reply View Replies (4)

Resolved SQLSTATE[42000]

  1. MrX
    MrX
  2. Bug Report
  3. Tuesday, September 08 2015, 05:07 PM
Hi,

since I have installed the Social Network plugin I got a SQL error when I click either on any user profile or on the Social Network Menu. This is what I got:

SQLSTATE[42000]: Syntax error or access violation: 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 '.`0`.`0`' at line 1

Not sure if this depends on the database configuration of CakePhp. I tried to use the key 'quoteIdentifiers' and set it to true as they say on the CakePhp online guide but the error was still there. Any idea?

Thanks

(The website is still in development so it isn't online)
Responses (4)
admin
admin Accepted Answer
Admin
Hi,
(The website is still in development so it isn't online)
without checking your site we can't find the problem, please specify your environment details, we will try to test on same system:
- Web server type and version
- Mysql version
- Easy Profile and Social network plugin version
- Operating system details
- List of third-party components installed
- Template name and provider
  1. more than a month ago
  2. Bug Report
  3. # 1
MrX
MrX Accepted Answer
Content Protected
  1. more than a month ago
  2. Bug Report
  3. # 2
admin
admin Accepted Answer
Admin
Have you a database name with "." char?
  1. more than a month ago
  2. Bug Report
  3. # 3
MrX
MrX Accepted Answer
Yes. The name is something like "db_name1.0.0". Now I see that the error "...for the right syntax to use near '.`0`.`0`' at line 1" refers to the DB name.

I have used the fix you wrote for the user Marco Dings and now it works like a charm!

Thanks!

(I don't know how to accept the answer since it is not in my post)
  1. more than a month ago
  2. Bug Report
  3. # 4
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.