The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#231
|
|||
|
|||
Why can't you have the counter table you run REPLACE INTO on the slave server?
Master: vB Slave: Replicated vB + counter table + sphinx Should work fine :O |
#232
|
|||
|
|||
orban, any suggestions for my problem?
|
#233
|
|||
|
|||
If you can reproduce the error with "search" I'd try the sphinx forums....or does it only happen when using sphinxapi.php?
|
#234
|
|||
|
|||
The slave server as far as i know(and im pretty sure) has only read permissions hence the replace will have to be run on the master (which is then obv replicated across) so i cannot write to the slave db at all.
Neil |
#235
|
|||
|
|||
Nothing can prevent you from creating a new table in the replicated db on the slave - granted your db user has the create/update privileges on that db. So your assertion that the slave is read-only isn't true.
(Actually nothing prevents you from messing with replicated tables on the slave, too - which obviously will break the replication integrity) |
#236
|
|||
|
|||
Quote:
Code:
Warning: assert() [function.assert]: Assertion failed in /sphinxapi.php on line 284 Query '' retrieved 0 of 0 matches in 0.000 sec. Query stats: 'barnacles' found 11 times in 11 documents looks like i may have solved the problem by using the array_walk and intval approach as discussed by orban and alanjay. strange thing is that my forums are running vb 3.6.1, not 3.0.x for which the discussion was originally intended. |
#237
|
|||
|
|||
Hm. We're running into that "search results are out of order" bug again, even if a user has the sort set to by date, rather than relevancy.
Has anyone else using this run into it? |
#238
|
|||
|
|||
Quote:
the values are numerals but sometimes they seem to be stored as strings no idea why but array_walk and intval seem to resolve the issue simply enough. By the way for anyone interested I have now used Sphix to create a search interface to both our news and forums databases outside of vBulletin. Next step to implement the sort order (which jsut needs to be made pretty). You can see the tool at http://www.digitalspy.co.uk/search/ds-search.php |
#239
|
|||
|
|||
Quote:
Anyway, I am also running into the results out of order bug. I haven't changed anything, and it just seemed to start cropping up one day. |
#240
|
|||
|
|||
Yeah, my users are complaining about the out of order results, but I haven't had the time lately to delve into it. I swear at one point it was working, but now.. not so much.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|