Problem with 2.4 Release: 20070822

[Publicite_Sexe]

Hello All,

Version 2.4 Release: 20070822 upgraded and installed by Hostonnet on my host during september.
The script run but there is a little error not yet added into the support forum I think.

Process Queue :

Unable to execute query: SELECT count(*) as total from `process_queue` as p, `signup` as s where p.user=s.username ORDER BY `status`asc
Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='

When I go to Domain/cron.php :

Running cron.php
CRON: 0 or the value 1

When I go to the Domain/convert.php :

ERROR: Unable to execute query

SELECT * FROM sconfig

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

- - - - - -

Videos added like an user or imported are added into the flvideo folder and into the video folder. But is there a debug.txt file into the templates_c folder without any informations about the new videos added. Nothink too into the "Approve Videos" section into the admin or into the "All videos".

The cron job is : /usr/bin/php -q /home/youtubec/public_html/cron.php > /dev/null &
Every 5 minutes.

Could you tell me where is the problem, please ?

Thank you for your help,
Regards,
Georges

[Publicite_Sexe]

Hello All,

Any person have a solution, suggestion or a link with an approximate problem into the forum ?

Thank you for your help,
Regards,
Georges

[Publicite_Sexe]

It's not possible, now !

When Mister hostonet was re-instaled a good version of vShare this month, I have directly maked a full backup of all files replaced on my host.

Now, I have just re-uploaded the upload.php file and I have this error :

Fatal error: Incompatible file format: The encoded file has format ID 3120702, which is too old in /home/xxxxxxxxxxx/public_html/upload.php on line 0

I use many PHP script, but this one is not stable, I think !

Anybody have a upload.php file correct, please ?

Sincerly I don't understand why these problems comes at any change from any files of the script.

Regards,
Georges

[admin]

Unable to execute query: SELECT count(*) as total from `process_queue` as p, `signup` as s where p.user=s.username ORDER BY `status`asc
Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='

This is due to wrong collations set as default on the server. You can edit the table "process_queue" in phpMyadmin and set collations to none to fix it.

As for upload.php, your files seems corrupted, you need to download the file again and upload to your web site in BINARY mode.

Since upgrade is done by hostonnet, you can contact them to get the problem fixed.

[admin]

Fatal error: Incompatible file format: The encoded file has format ID 3120702, which is too old in /home/xxxxxxxxxxx/public_html/upload.php on line 0

File will not get corrupted by itself. It should be you or some one else tried to modify or re upload the file in wrong format.

[Publicite_Sexe]

Unable to execute query: SELECT count(*) as total from `process_queue` as p, `signup` as s where p.user=s.username ORDER BY `status`asc
Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='

This is due to wrong collations set as default on the server. You can edit the table "process_queue" in phpMyadmin and set collations to none to fix it.

As for upload.php, your files seems corrupted, you need to download the file again and upload to your web site in BINARY mode.

Since upgrade is done by hostonnet, you can contact them to get the problem fixed.

Hello Admin,

Thank you for your answer.
The "upload.php" file is OK now.

But, cout you explain this, please ?

This is due to wrong collations set as default on the server. You can edit the table "process_queue" in phpMyadmin and set collations to none to fix it.

What can I do to resolve this ? What's "collation" ?

Thank you for your help,
Regards,
Georges