PDA

View Full Version : SQL error on install VBA CMS 410


Mick2015
05-20-2011, 08:45 PM
imtrying to install VB CMS 410 on my VB 4.1.3 forums and its kept comeing up as an error in the sql after updating the stlyes


Database error in vBulletin 4.1.3:

Invalid SQL:

SELECT templateid
FROM template
WHERE
edited=1;
MySQL Error : Unknown column 'edited' in 'where clause'
Error Number : 1054
Request Date : Friday, May 20th 2011 @ 07:41:40 PM
Error Date : Friday, May 20th 2011 @ 07:41:56 PM
Script : http://www.xxxxx.com/forums/admincp/vbacmps_install.php
Referrer : http://www.xxxxx.com/forums/admincp/vbacmps_install.php
IP Address : 94.170.30.112
Username : NCC 24656
Classname : vB_Database
MySQL Version : 5.0.91-community-log


also once i try to go back to forums this eror shows
Fatal error: Call to undefined function print_portal_output() in /home/clantsu/public_html/index.php on line 44



any advace would be greatfull

Brian
05-21-2011, 01:22 PM
The SQL error is not from a query within any of the CMPS files and I'm pretty sure vB does not have a column named 'edited' in the 'template' table by defalt, so it sounds more like you have another product/plugin installed that's causing the SQL error. Try disabling any other products and then re-installing the CMPS. If you still receive the print_portal_output() error afterward, go to Admin CP => Plugins & Products => Manage Products and make sure that vBa CMPS is enabled there.