+ Reply to Thread (include dating software, release, and patch number!)
Results 1 to 8 of 8

Thread: Database Access Error

  1. #1

    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?

  2. #2
    Administrator Smoge's Avatar
    Join Date
    Mar 2005
    Posts
    6,440
    Blog Entries
    5

    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.

  3. #3

    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

  4. #4

    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'

  5. #5

    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'

  6. #6
    Administrator Smoge's Avatar
    Join Date
    Mar 2005
    Posts
    6,440
    Blog Entries
    5

    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.

  7. #7

    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

  8. #8
    Administrator Smoge's Avatar
    Join Date
    Mar 2005
    Posts
    6,440
    Blog Entries
    5

    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.

+ Reply to Thread (include dating software, release, and patch number!)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Similar Threads

  1. Database Access Error
    By biggles in forum General Troubleshooting
    Replies: 7
    Last Post: 04-07-2009, 09:13 PM
  2. Database access error
    By x151x in forum General Troubleshooting
    Replies: 3
    Last Post: 06-14-2007, 03:55 AM
  3. Database access error after database upload
    By sanne in forum Database
    Replies: 1
    Last Post: 06-03-2007, 06:49 AM
  4. Database access error
    By BeastMaster in forum Bugs Dolphin v.5.3.0
    Replies: 4
    Last Post: 04-10-2007, 03:36 PM
  5. Database access error
    By TheOutdoors in forum General Troubleshooting
    Replies: 2
    Last Post: 10-01-2006, 02:14 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts