Thread: Dolhin 6.0 Beta Database query error!

Dolphin 6.0 Beta Release

I get the following error message when I try to upload a group picture. Did anyone has the same?


Database query error
Query:
SELECT `Groups`.*, `GroupsCateg`.`Name` AS `categName`, COUNT( `GroupsMembers`.`memberID` ) AS `membersCount`, `Groups`.`thumb`, `GroupsGallery`.`ext` AS `thumbExt`, `GroupsGallery`.`seed` FROM `Groups`,`GroupsCateg` LEFT JOIN `GroupsGallery` ON `Groups`.`thumb` = `GroupsGallery`.`ID` LEFT JOIN `GroupsMembers` ON `GroupsMembers`.`groupID` = 1 AND `GroupsMembers`.`status` = 'Active' WHERE `Groups`.`ID` = 1 AND `GroupsCateg`.`ID` = `Groups`.`categID` GROUP BY `Groups`.`ID`
Mysql error:
Unknown column 'Groups.thumb' in 'on clause'
Found error in file
/home/iblog3/public_html/comm1/inc/groups.inc.php
at line 167.
Tried to call db_assoc_arr function with erroneous parameter #0


Debug backtrace:

Array
(
[1] => Array
(
[file] => /home/iblog3/public_html/comm1/inc/db.inc.php
[line] => 119
[function] => db_res
[args] => Array
(
[0] =>
SELECT
`Groups`.*,
`GroupsCateg`.`Name` AS `categName`,
COUNT( `GroupsMembers`.`memberID` ) AS `membersCount`,
`Groups`.`thumb`,
`GroupsGallery`.`ext` AS `thumbExt`,
`GroupsGallery`.`seed`
FROM `Groups`,`GroupsCateg`
LEFT JOIN `GroupsGallery`
ON `Groups`.`thumb` = `GroupsGallery`.`ID`
LEFT JOIN `GroupsMembers`
ON
`GroupsMembers`.`groupID` = 1 AND
`GroupsMembers`.`status` = 'Active'
WHERE
`Groups`.`ID` = 1 AND
`GroupsCateg`.`ID` = `Groups`.`categID`
GROUP BY `Groups`.`ID`

[1] => 1
)

)

[2] => Array
(
[file] => /home/iblog3/public_html/comm1/inc/groups.inc.php
[line] => 167
[function] => db_assoc_arr
[args] => Array
(
[0] =>
SELECT
`Groups`.*,
`GroupsCateg`.`Name` AS `categName`,
COUNT( `GroupsMembers`.`memberID` ) AS `membersCount`,
`Groups`.`thumb`,
`GroupsGallery`.`ext` AS `thumbExt`,
`GroupsGallery`.`seed`
FROM `Groups`,`GroupsCateg`
LEFT JOIN `GroupsGallery`
ON `Groups`.`thumb` = `GroupsGallery`.`ID`
LEFT JOIN `GroupsMembers`
ON
`GroupsMembers`.`groupID` = 1 AND
`GroupsMembers`.`status` = 'Active'
WHERE
`Groups`.`ID` = 1 AND
`GroupsCateg`.`ID` = `Groups`.`categID`
GROUP BY `Groups`.`ID`

)

)

[3] => Array
(
[file] => /home/iblog3/public_html/comm1/group.php
[line] => 57
[function] => getgroupinfo
[args] => Array
(
[0] => 1
)

)

)

Same here,

Happens when going to the homepage and join page and adding new profiles from admin...anyone solution??

When i want to the upgrade NEW boonex patch i get this error too

WHEN i want start upgrade.php i get this QUERY ERROR :s

Anyone a solution for this problem? Smoge...?

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:
Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'find_in_set'

dolphin 6.0.1 patch error -- Illegal mix of collations

Fixed :

Edit inc/db.inc.php -- function db_res, somewhere in line #104 comment this :

//mysql_query( "SET NAMES 'utf8'" );

Warning: file_get_contents(http://www.lovefor2.nl/dating/groups...ass=&trans=1): failed to open stream: HTTP request failed! �����Z|I�-A in /var/www/vhosts/lovefor2.nl/httpdocs/dating/group.php on line 245


i get this on top of the page and the layout shiftst to the left.
I guess it has to do with ray?

when i type www.mysite.com/upgrade.php i get this message

"Error
Database query error"

Again ... why??

Originally Posted by BAVARAC

when i type www.mysite.com/upgrade.php i get this message

"Error
Database query error"

Again ... why??

go here : Dolhin 6.0 Beta Database query error!

Yes and ...??

I read this ... change ... and error show again ... :S:S:S

Originally Posted by BAVARAC

Yes and ...??

I read this ... change ... and error show again ... :S:S:S

I think the only thing you need to do now is start from the beginning or get back to the instruction check if you did it right.

instruction to fix it :
Dolhin 6.0 Beta Database query error!


Have fun!!!