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

Thread: Getting these mails, Database error in Dating site Query:

  1. #1
    birkenstam's Avatar
    Join Date
    Mar 2006
    Posts
    205

    Default Getting these mails, Database error in Dating site Query:

    Smoge do you know what these e-mails i get all the time means?


    Code:
    Database error in Dating site
    Query:
    SELECT MAX( FLOOR( `join_page` / 1000 ) ) FROM `ProfilesDesc` WHERE `visible` & 2 AND (FIND_IN_SET('0',`show_on_page`) OR FIND_IN_SET('3',`show_on_page`))
    
    Mysql error:
    Table 'asdfgh_date.ProfilesDesc' doesn't exist
    
    Found error in file /home/asdfgh/public_html/join_form.php
    at line 58. Called db_arr function 
    with erroneous argument #0
    
    Debug backtrace:
    Array
    (
        [1] => Array
            (
                [file] => /home/asdfgh/public_html/inc/db.inc.php
                [line] => 104
                [function] => db_res
                [args] => Array
                    (
                        [0] => SELECT MAX( FLOOR( `join_page` / 1000 ) ) FROM `ProfilesDesc` WHERE `visible` & 2 AND (FIND_IN_SET('0',`show_on_page`) OR FIND_IN_SET('3',`show_on_page`))
                        [1] => 1
                    )
    
            )
    
        [2] => Array
            (
                [file] => /home/asdfgh/public_html/join_form.php
                [line] => 58
                [function] => db_arr
                [args] => Array
                    (
                        [0] => SELECT MAX( FLOOR( `join_page` / 1000 ) ) FROM `ProfilesDesc` WHERE `visible` & 2 AND (FIND_IN_SET('0',`show_on_page`) OR FIND_IN_SET('3',`show_on_page`))
                    )
    
            )
    
    )
    
    
    Called script: /join_form.php
    
    Request parameters:
    Array
    (
    )
    Last edited by birkenstam; 07-20-2009 at 01:16 PM.
    Regards Anders
    I wish i could code
    My specialities Copy Paste with instruction
    swedish dating version dolphin 6.1.5

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

    Default

    Did you test your join after doing your upgrade? See it works?

    Remember, whenever you do something on your site that could affect join - like doing the upgrade you did - you should test join.

    Table 'asdfgh_date.ProfilesDesc' doesn't exist

    Is the error - and this is because you have code on your site, that tries to use this old table - which is no longer in use.

    You need to hunt it down.

    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 query error in join
    By bara.munchies in forum General Troubleshooting
    Replies: 2
    Last Post: 06-14-2010, 09:29 AM
  2. Database query error
    By snobearak in forum Dolphin General Discussion v6.00 and above
    Replies: 13
    Last Post: 09-24-2008, 10:10 PM
  3. Join - Database query error
    By merageeth in forum General Troubleshooting
    Replies: 3
    Last Post: 03-27-2008, 09:43 AM
  4. Admin Login.. Database Query Error???
    By cantholdback in forum General Troubleshooting
    Replies: 3
    Last Post: 02-14-2008, 12:27 AM
  5. Dolhin 6.0 Beta Database query error!
    By dfred in forum Bugs Dolphin 6.00 Alpha / Beta / RC
    Replies: 10
    Last Post: 09-17-2007, 06:46 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