Database Access Error
Dolphin script is 5.6.0005
Hi,
I'm a newbie here and I'm not getting much joy from the support people.
Whenever I try to enter a new profile or change either my profile as a member or any profile in admin I keep getting a database access error. I've checked that my database details are correct in Modules but the problem persists.
Can anyone help me?
When you get a database error, an email will be sent to the debug email you setup in your /inc/header.inc.php
If you want, copy and paste the contents of one of these emails ans we can take a look.
Warm regards,
Smoge
ModMySite Administrator
Problems? Questions? Need modifications or other help with your site?
Open A Ticket , Send Us An Email Or Give Us A Telephone Call +1 518-632-4152.
Problem was resolved ..
I think that the problem was, messages go to the activation of NotifyQueue I emptied, but I have a question on the table what Vidth NotifyQueue
There is now another problem
This is wrong, Emile
Error in /ar/profile.php: 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 'AND `Picture` = '1' ORDER BY RAND() LIMIT 10' at line 1Query: 'SELECT `ID`, `NickName`, `Sex`, `Pic_0_addon`, `Sound` FROM `Profiles` WHERE AND `Picture` = '1' ORDER BY RAND() LIMIT 10'
problem
This is wrong, Emile
Error in /ar/profile.php: 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 'AND `Picture` = '1' ORDER BY RAND() LIMIT 10' at line 1Query: 'SELECT `ID`, `NickName`, `Sex`, `Pic_0_addon`, `Sound` FROM `Profiles` WHERE AND `Picture` = '1' ORDER BY RAND() LIMIT 10'
WHERE AND
should perhaps be only
WHERE
Did you edit this query?
Smoge
ModMySite Administrator
Problems? Questions? Need modifications or other help with your site?
Open A Ticket , Send Us An Email Or Give Us A Telephone Call +1 518-632-4152.
Did not solve the problem this
This is not the same problem
The first problem was solved .. But I have this problem
This is the message which comes to e-mail me
Error in /ar/profile.php: 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 'AND `Picture` = '1' ORDER BY RAND() LIMIT 10' at line 1Query: 'SELECT `ID`, `NickName`, `Sex`, `Pic_0_addon`, `Sound` FROM `Profiles` WHERE AND `Picture` = '1' ORDER BY RAND() LIMIT 10'
Is there a solution to this problem?? Or not
Well... WHERE AND is not valid SQL... so the solution is perhaps you properly debugging your code / site, or getting someone who knows how to debug your site to debug it.Originally Posted by lo2y
Smoge
ModMySite Administrator
Problems? Questions? Need modifications or other help with your site?
Open A Ticket , Send Us An Email Or Give Us A Telephone Call +1 518-632-4152.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks