database error

Hello, I update dolphin 6.0 to dolphin 6.1 and receive this error email:

Database error in mysite
Query:
INSERT INTO `Profiles` SET  `LastReg` = NOW()

Mysql error:
Unknown column 'LastReg' in 'field list'

Found error in file C:\xampp\vhosts\mysite.it\httpdocs\join_form.php
at line 334. Called db_res function
with erroneous argument #0

Debug backtrace:
Array
(
[1] => Array
(
[file] => C:\xampp\vhosts\mysite.it\httpdocs\join_form.php
[line] => 334
[function] => db_res
[args] => Array
(
[0] => INSERT INTO `Profiles` SET  `LastReg` = NOW()
)

)

[2] => Array
(
[file] => C:\xampp\vhosts\mysite.it\httpdocs\join_form.php
[line] => 77
[function] => PageCompPageMainCode
[args] => Array
(
)

)

)


Called script: /join_form.php

Request parameters:
Array
(
)

AND:

Database error in mysite
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` = 'mary' )
ORDER BY
1 DESC,
Profiles.LastLoggedIn DESC
LIMIT 0, 10


Mysql error:
Unknown column 'LastNavTime' in 'field list'

Found error in file C:\xampp\vhosts\mysite.it\httpdocs\search_result.php
at line 575. Called db_res function
with erroneous argument #0

Debug backtrace:
Array
(
[1] => Array
(
[file] => C:\xampp\vhosts\msysite.it\httpdocs\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` = 'mary' )
ORDER BY
1 DESC,
Profiles.LastLoggedIn DESC
LIMIT 0, 10

)

)

)


Called script: /search_result.php

Request parameters:
Array
(
[tag] => mary
)

AND:

Database error in mysite
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` = 'figa' )
ORDER BY
1 DESC,
Profiles.LastLoggedIn DESC
LIMIT 0, 10


Mysql error:
Unknown column 'LastNavTime' in 'field list'

Found error in file C:\xampp\vhosts\mysite.it\httpdocs\search_result.php
at line 575. Called db_res function
with erroneous argument #0

Debug backtrace:
Array
(
[1] => Array
(
[file] => C:\xampp\vhosts\mysite.it\httpdocs\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` = 'figa' )
ORDER BY
1 DESC,
Profiles.LastLoggedIn DESC
LIMIT 0, 10

)

)

)


Called script: /search_result.php

Request parameters:
Array
(
[tag] => figa
)

HELP ME PLEASE Cry

Quote · 9 Feb 2009

UP Frown

Quote · 10 Feb 2009
 
 
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.