Slave Database Configuration

[GNDI]

Hi I'm trying to add a slave DB to my board, but keep getting errors

I configured the slave server and tested the connection, and all works fine.
Then i copied the corrent DB to the slave... No errors.

BUT then i configured the ./config.php to connect to the slave DB and that seems to work fine, but when i try to post a reply or new thread, then it comes whit an error

Here is the output




Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT MAX(dateline) AS dateline
FROM post AS post
WHERE threadid = 666
AND dateline <
AND visible = 1;

MySQL Error : 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 'AND visible = 1' at line 5
Error Number : 1064
Date : Friday, February 17th 2006 @ 06:07:43 AM
Script : http://xxxxxx/newreply.php
Referrer : http://xxxxxxx/showthread.php?t=3656&goto=nextoldest
IP Address : xxxxx
Username : BSD
Classname : vb_database

Please give me a sollution

[GNDI]

PS. When I move the slave server from config.php the post comes out in double ??

[Steve Machol]

SQL Syntax errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any hacks or plugins, then see if you still have this problem.

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?

[GNDI]

nope didn't help at all

I setup a test forum at http://delfina.dk the entire installation went fine no errors BUT when I try to log in in the admin area it's keep sending be back to the log in screen, and the forum /index.php page keep updating it self? very very strenge I think

And this is from a fresh downloadet VB .zip from costum area.

[Steve Machol]

Honestly, this will be the first time I've ever seen an SQL Syntax error on an unhacked and unmodified vBulletin site.

Fill out a support ticket at:

http://members.vbulletin.com/membersupport_contactform.php

Be sure to include the login info to your unmodified vB Admin CP, phpMyAdmin and FTP. Please also include a complete description of the problem.

[Scott MacVicar]

Slave database support is still experimental, I suggest you only use it for searches at this moment in time.

You can do this by adding modifying your config.php and add

if (THIS_SCRIPT == 'search') around the slave parts of the file.

[Steve Machol]

FWIW as per your support ticket some of the problems you are having are because you are using vB 3.5.0 files with a 3.5.3 database.

[GNDI]

FWIW as per your support ticket some of the problems you are having are because you are using vB 3.5.0 files with a 3.5.3 database.

Then you have serius problems whit your zip files, since all I uploaded to delfina.dk is from a fresh zip of yours

[Steve Machol]

If so, this would be the first time I've ever heard of this happening. Regardless of how it happened, you need to use the 3.5.3 files. 3.5.0 files will not work with a 3.5.3 database.

[GNDI]

If so, this would be the first time I've ever heard of this happening. Regardless of how it happened, you need to use the 3.5.3 files. 3.5.0 files will not work with a 3.5.3 database.

well it would be nice, if you added ALL 3.5.3 files to the zip. When you have done this, I'll download it again, and we can try one more time

[Steve Machol]

I apologize, I got your ticket confused with another one. Trying to do too many things at once. My bad.

[GNDI]

I apologize, I got your ticket confused with another one. Trying to do too many things at once. My bad.

Thats ok

But please comferm that this is all 3.5.4 files in this fresh download of 3.5.4



By the way you was talking about this:

You can do this by adding modifying your config.php and add

if (THIS_SCRIPT == 'search') around the slave parts of the file."

well I'm a PHP idiot, so please help like a two year old girl.

This is the slave script:


// ****** SLAVE DATABASE CONFIGURATION ******
// If you have multiple database backends, this is the information for your slave
// server. If you are not 100% sure you need to fill in this information,
// do not change any of the values here.
$config['SlaveServer']['servername'] = 'xxx.xxxxx.TLD';
$config['SlaveServer']['port'] = xxxx;
$config['SlaveServer']['username'] = 'xxxxxx';
$config['SlaveServer']['password'] = 'xxxxx';
$config['SlaveServer']['usepconnect'] = 0;

Where excatly to put your script

[GNDI]

Are you still here?

[Zachery]

Please, NEVER EVER ever do that again, do you relize you've just broken the license agreement on a massive level by shareing your ENTIRE vbulletin zip file?

I am putting in a request to have that removed.

[GNDI]

well since it's imposible to upload it here, and it still say

vBulletin 3.5.3 Admin Control Panel

After upgrade to 3.5.4 I saw no other choise than put it on a public server in some kind. And as you notice yourself, it's easy to get file moved from megaupload.com, therefore i did this.

But do you have an answer to my coding question?