Error
Database query error
Receiving this error when a NEW user attempts to join the Site. I guess it is coming from the join.php file? Any idea how to fix this?
Dolaugh
Database Error
 |
Enable error reporting and showing error: db.inc.php and you will able to see error more detailed |
I have problem too - this e-mail : Database error in Site de Relacionamentos
Query:
SELECT DISTINCT
`Profiles`.*,
(LastNavTime > SUBDATE(NOW(), INTERVAL 5 MINUTE)) as is_onl
FROM Profiles
INNER JOIN `Tags` USING( `ID` ) WHERE Status = 'Active' AND `Tags`.`Type`
= 'profile' AND ( `Tags`.`Tag` = 'amor' )
ORDER BY
1 DESC,
Profiles.LastLoggedIn DESC
LIMIT 0, 10
Mysql error:
Unknown column 'LastNavTime' in 'field list'
Found error in file /home/rela2/public_html/search_result.php
at line 575. Called db_res function
with erroneous argument #0
Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/rela2/public_html/search_result.php
[line] => 575
[function] => db_res
[args] => Array
(
[0] =>
SELECT DISTINCT
`Profiles`.*,
(LastNavTime > SUBDATE(NOW(), INTERVAL 5 MINUTE)) as is_onl
FROM Profiles
INNER JOIN `Tags` USING( `ID` ) WHERE Status = 'Active' AND `Tags`.`Type`
= 'profile' AND ( `Tags`.`Tag` = 'amor' )
ORDER BY
1 DESC,
Profiles.LastLoggedIn DESC
LIMIT 0, 10
)
)
)
Called script: /search_result.php
Request parameters:
Array
(
[tag] => amor
)
--
Auto-report system
My site - http://www.rela2.senior.eti.br/index.php and not show more statistics ...
|
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.
The new Dolphin solution is powered by UNA Community Management System.