Thread: 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
(
)

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