PDA


View Full Version : Error when trying to edit a module


attroll
08-10-2007, 02:42 PM
No matter what module I try to edit I get an error. This hapends to every module I try to edit and it does it when I click on save

Database error in vBulletin 3.6.1:

Invalid SQL:
UPDATE adv_dyna_modules SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Calendar',
`description` = 'A small calendar showing links to entries posted on each day of the month.',
`active` = '1',
`filename` = 'dyna_calendar.php',
`parent` = '',
`templatelist` = 'adv_dyna_module_calendar_day\r\nadv_dyna_module_calendar_week\r\nadv_dyna_modul e_calendar_header\r\nadv_dyna_module_calendar_wrapper\r\ncalendar_smallmonth_wee k\r\ncalendar_smallmonth_day_other',
`useredit` = '0',
`options` = '0',
`useshell` = '1',
`altshell` = '',
`link` = '',
`colspan` = '8',
`formcode` = '<script type=\"text/javascript\" src=\"clientscript/vba_dyna_ajax_calendar.js\"></script>',
`inctype` = 'php_file',
`identifier` = 'calendar',
`userperms` = 'a:19:{i:1;i:1;i:2;i:7;i:3;i:7;i:4;i:7;i:5;i:7;i:6;i:7;i:7;i:7;i:10;i:7;i:13;i:7 ;i:19;i:7;i:20;i:7;i:22;i:7;i:25;i:7;i:26;i:7;i:27;i:7;i:29;i:7;i:31;i:7;i:32;i: 7;i:33;i:7;}'
WHERE modid = 1;

MySQL Error : Unknown column 'altshell' in 'field list'
Error Number : 1054
Date : Friday, August 10th 2007 @ 12:38:36 PM
Script : http://www.mysite.net/forum/admincp/vba_dyna_admin_modules.php
Referrer : http://www.mysite.net/forum/admincp/vba_dyna_admin_modules.php?do=editmodule&modid=1&s=
IP Address : 64.185.128.137
Username : attroll
Classname : vb_database

Brian
08-10-2007, 07:05 PM
That's a new column that was added in RC1, and your footer is still showing 'Powered by: vBadvanced Dynamics v1.0 Beta 3', so it looks like you didn't run the upgrade script after uploading the RC1 files.

attroll
08-11-2007, 01:49 AM
That was my bust. Your right I did not run the upgrade script.