Bug Update error on 1.0.14

[AnjaC]

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

 

[Fillip H.]

This can be resolved by uploading all the files that came with v1.0.14

 

[AnjaC]

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

 

[Robert9]

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.

 

[AnjaC]

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

 

[Fillip H.]

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.

 

[AnjaC]

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

 

[Fillip H.]

If you open up /includes/functions.php and find

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

replace it with

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

 

[AnjaC]

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

 

[AnjaC]

1.0.13 is also working like a charme!

Greetings

Klaus