XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk




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
Topic | Forum


2
Javacup
Re: SecurityImage not functioning properly

  • 2007/6/28 8:15

  • Javacup

  • Just popping in

  • Posts: 5

  • Since: 2007/6/26


Quote:

tzvook wrote:
I wrote in the "happy-linux" forums 2 weeks ago about it with no answere, so I am sorry, but I have to advise to "think twice" before using the module "as is" now ... especially if you have a lot of visitors !!! .... as this module is a "MySql queries" bomb


Hi,
it's too late for me of reconsiderer my choice of module, 2 years that I turn with weblinks on 2 site of production and everyday i have about thirty site of Spam to erase, there are 2 day I tested the version 1.44 and frankly i like this version only on my localhost all functions with captcha, happy linux and rssc and on the submit.php appear the error correcting code but not the categories and the test in server web I have an error 500 then I returned on my version 0.97 while hope to make function the security image and also if you to convert a base of data weblinks 97 towards a bdd weblinks 1.44 thank you in advance for your assistance

excuse me translation google
Topic | Forum


3
Javacup
Re: SecurityImage not functioning properly

  • 2007/6/28 7:55

  • Javacup

  • Just popping in

  • Posts: 5

  • Since: 2007/6/26


Quote:

Have you installed the security-image and tested/used it with other modules ?


Hi,

I have installed security-image and fonction well with news 1.54, Contact us, Comments.
Topic | Forum


4
Javacup
Re: SecurityImage not functioning properly

  • 2007/6/27 11:31

  • Javacup

  • Just popping in

  • Posts: 5

  • Since: 2007/6/26


Hi,

here

PHP Version 4.4.7
MySQL Version 5.0
Xoops Version 2.0.16 french
Weblinks Version 0.97 stable
OS : Linux infong 2.4


tks tzvook :)
Topic | Forum


5
Javacup
Re: SecurityImage not functioning properly

  • 2007/6/26 17:33

  • Javacup

  • Just popping in

  • Posts: 5

  • Since: 2007/6/26


with your code I have an error message
Quote:
Parse error: parse error, unexpected T_ELSEIF in /xxxx/xxx/xxxx/xxx/xxxx/modules/weblinks/submit.php on line 169

help me plz

thks
Topic | Forum



TopTop



[Advanced Search]

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

301 user(s) are online (109 user(s) are browsing Support Forums)

Members: 0

Guests: 301

more...

Donat-O-Meter

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

Latest GitHub Commits