Status
Not open for further replies.

AnjaC

Customer
Hi!

When we update any modification we always close the board during the install and file upload process.

When updating dbseo to the latest version we can´t open or reclose the board because of the following error:

Warnung: require([path]/dbtech/dbseo/hooks/admin_options_processing.php) [function.require]: failed to open stream: No such file or directory in [path]/includes/adminfunctions_options.php(490) : eval()'d code (Zeile 210)

Fatal error: require() [function.require]: Failed opening required '/home/xxx/xxx/xxx/forum/dbtech/dbseo/hooks/admin_options_processing.php' (include_path='.:/usr/share/php:/usr/share/pear') in /home/www/web211/html/vbulletin/includes/adminfunctions_options.php(490) : eval()'d code on line 210

Any idea ws any help would be great!

Btw, we had to go back to the Version before!

Thanks and greetings

Klaus
 
O.k., we did it, the result is this:

Invalid SQL:

SELECT IF(visible = 2, 1, 0) AS isdeleted,



thread.*

, post.pagetext AS description
FROM vb3_thread AS thread





LEFT JOIN vb3_post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid = 181068;

MySQL-Fehler : Column 'visible' in field list is ambiguous
Fehler-Nr. : 1052

What can we do?

Thanks!

Greetings

Klaus
 
If a field is ambigous you just set the table-name in front to tell mysql which field you want.

table-name.visible

Probably from thread? Just watch which tables are selected.
 
Thanks, Robert, sorry, i don´t know what to do. The installtion went throug, but when calling a url the result ist the error i described already.

Greetings

Klaus
 
Last edited:
O.k., we did it, the result is this:

Invalid SQL:

SELECT IF(visible = 2, 1, 0) AS isdeleted,



thread.*

, post.pagetext AS description
FROM vb3_thread AS thread





LEFT JOIN vb3_post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid = 181068;

MySQL-Fehler : Column 'visible' in field list is ambiguous
Fehler-Nr. : 1052

What can we do?

Thanks!

Greetings

Klaus
Please update to the latest version of vB 3.8. At the time of writing this is vB 3.8.8 Beta 2. Your version of MySQL is incompatible with your older version of vB3.8.
 
Fillip, our MySQL Version is 5.0.51a, vbulletin version is 3.8.7 Patch Level 4 and we can´t use a Beta version because this would cause much more problems with other addons we have to use.

The board is a business board, no hobby platform to test versions or addons.

Sorry!

We must have another solution or we can´t upadate your addons in future. vbulletin 4 and 5 are complete unsuable for our business!

Greetings

Klaus
 
If you open up /includes/functions.php and find
Code:
SELECT IF(visible = 2, 1, 0) AS isdeleted,
replace it with
Code:
SELECT IF(thread.visible = 2, 1, 0) AS isdeleted,
 
Thanks, Fillip!

1.0.12 is working fine! I will try 1.0.13 tomorrow and then test the last version with your fix!

Support is great!

Greetings

Klaus
 
Status
Not open for further replies.

Legacy DragonByte SEO

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
7,172
Customer rating
5.00 star(s) 1 ratings
Back
Top