1
Javacup
Problem with CBB 3.0.8 in mysql 3.23
  • 2008/3/5 13:17

  • Javacup

  • Just popping in

  • Posts: 5

  • Since: 2007/6/26


Hi,

I have make an update CBB 1.16 to 3.0.8 with the version MySQL 5.0.32 and I did not have a problem.
Only,now I change the server, and I transferred all my site on the new server with version MySQL 3.23.
I have the same file CBB 3.08 and same BDD and and I gave the same permission but I have errors of permission and syntaxe sql in the module.
Quote:
cleanOrphanELETE xoops_bb_posts_text FROM xoops_bb_posts_text LEFT JOIN xoops_bb_posts AS aa ON xoops_bb_posts_text.post_id = aa.post_id WHERE (aa.post_id IS NULL)
cleanOrphanELETE xoops_bb_moderates FROM xoops_bb_moderates LEFT JOIN xoops_bb_forums AS aa ON xoops_bb_moderates.forum_id = aa.forum_id WHERE xoops_bb_moderates.forum_id > 0 AND (aa.forum_id IS NULL)
You have an error in your SQL syntax near 'xoops_bb_reads_forum FROM xoops_bb_reads_forum LEFT JOIN xoops_bb_reads_forum AS' at line 1
You have an error in your SQL syntax near 'xoops_bb_reads_topic FROM xoops_bb_reads_topic LEFT JOIN xoops_bb_reads_topic AS' at line 1

and when one clicks on a forum :
Quote:
Erreur : sujet non selectionné
Aucun forum n'a été selectionné


Version XOOPS : 2.0.18
Version framework : 1.22
version xoopseditor : 1.21
version php : 4.4.4
version MySQL : 3.23

somebody can help me

thks

Regards

2
visiting
Re: Problem with CBB 3.0.8 in mysql 3.23
  • 2008/6/13 15:48

  • visiting

  • Just popping in

  • Posts: 1

  • Since: 2008/6/13


multi table deletes are not supported until MySQL 4.0. http://dev.mysql.com/doc/refman/4.1/en/delete.html

so the
delete t1 from t1 join t2 where ...;
will not work.

Login

Who's Online

325 user(s) are online (258 user(s) are browsing Support Forums)


Members: 0


Guests: 325


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits