Go Back   ModMySite BoonEx Dolphin Support Forum > aeWebWorks aeDating / BoonEx Dolphin Dating Script > Dolphin General Discussion v5.3 to v5.6.5

Dolphin General Discussion v5.3 to v5.6.5 General issues about Dolphin - Smart Community Builder v5.3 to v5.6.5

Reply
 
LinkBack Thread Tools Display Modes
Old 04-07-2009   #1 (permalink)
 
Join Date: Nov 2007
Posts: 10
Default 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?
lo2y is offline   Reply With Quote
Old 04-07-2009   #2 (permalink)
Administrator
 
Smoge's Avatar
 
Join Date: Mar 2005
Posts: 6,171
Default

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.
Smoge is offline   Reply With Quote
Old 04-07-2009   #3 (permalink)
 
Join Date: Nov 2007
Posts: 10
Default

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 is offline   Reply With Quote
Old 04-07-2009   #4 (permalink)
 
Join Date: Nov 2007
Posts: 10
Default

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 is offline   Reply With Quote
Old 04-08-2009   #5 (permalink)
 
Join Date: Nov 2007
Posts: 10
Default 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 is offline   Reply With Quote
Old 04-08-2009   #6 (permalink)
Administrator
 
Smoge's Avatar
 
Join Date: Mar 2005
Posts: 6,171
Default

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.
Smoge is offline   Reply With Quote
Old 04-09-2009   #7 (permalink)
 
Join Date: Nov 2007
Posts: 10
Default

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
lo2y is offline   Reply With Quote
Old 04-09-2009   #8 (permalink)
Administrator
 
Smoge's Avatar
 
Join Date: Mar 2005
Posts: 6,171
Default

Quote:
Originally Posted by lo2y View Post
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.



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.
Smoge is offline   Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 08:54 AM.


Powered by vBulletin® Version 3.8.3
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.0
Contents Copyright 2003 to the End Of Time - ModMySite.Com