lo2y

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?

Smoge

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.

lo2y

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

lo2y

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'

lo2y

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'

Smoge

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.

lo2y

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

Smoge

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.



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.