PDA

View Full Version : error "Invalid SQL" Unknown column 'pt_issueid' in 'field list'


rbc
11-11-2013, 03:37 PM
Hi
I tried to import the vBulletin Project Tools 2.2.0 (https://vborg.vbsupport.ru/showthread.php?t=270346&highlight=project+tools) xml file.

i had a previous version of the project tools installed something for vb 4 xxxxxx
(what i mean is , i want to make an update .....)

i uploaded all files to my server and start the product import in admincp !!

Then this error appears ---


MySQL-Error : Unknown column 'pt_issueid' in 'field list'
Fehler-Nr. : 1054
Fehler-Zeit : Monday, 11.11.2013 @ 17:06:09
Datum : Monday, 11.11.2013 @ 17:06:09
Skript : xxxxxxxxxx/plugin.php?do=productimport
Referrer : xxxxxxxxxx/plugin.php?do=productadd
IP-Adresse : xx.xx.xx.xx
Benutzername : rbc
Klassenname : vB_Database
MySQL-Version : 5.0.70-log

Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 426
#1 vB_Database->execute_query() called in [path]/includes/class_core.php on line 459
#2 vB_Database->query_read() called in [path]/includes/adminfunctions_plugin.php(1199) : eval()'d code on line 65
#3 eval() called in [path]/includes/adminfunctions_plugin.php on line 1199
#4 install_product() called in [path]/admincp/plugin.php on line 1749



i did a search on vborg but i cant find only this old link :

I tried this (https://vborg.vbsupport.ru/showthread.php?t=256117&highlight=SELECT+threadid%2C+pt_issueid%2C+pt_forw ardmode+FROM+thread+WHERE+pt_issueid+%26gt%3B+0%3B ) and it does not work !

Does someone of you know a fix for this ?

I Use :
PHP Version 5.2.11-pl1-gentoo
MySQL-Version 5.0.70
vbulletin 4.2.1

thanks

ForceHSS
11-11-2013, 08:42 PM
When it says Unknown column this means you are missing a table but as that missing table is not default you need to post in the plugin used and ask them for help with this issue

rbc
11-12-2013, 07:10 AM
When it says Unknown column this means you are missing a table but as that missing table is not default you need to post in the plugin used and ask them for help with this issue


Hi ForceHSS

Thanks for your answer ...

then i will repost on the plugins page !

Thank you