Topic on Extension talk:MsCalendar

Hello.

Everytime I run update.php I get:

Creating mscal_list table ...[3dda57f2a2b626eeb8f4b017] [no req]   DBQueryError from line 1054 of /var/www/xxxxxxx/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: CREATE TABLE IF NOT EXISTS "mscal_names" (

 ID int UNSIGNED NOT NULL auto_increment,

 Cal_Name varchar(255) NOT NULL,

 PRIMARY KEY (ID)

 )

Function: Database::sourceFile( /var/www/249moore.st/extensions/MsCalendar/MsCalendar.sql )

Error: 42601 ERROR:  syntax error at or near "UNSIGNED"

LINE 2:  ID int UNSIGNED NOT NULL auto_increment,

                ^

I have the tried this with version 1.27 and 1.28 of the extension. Any help would be great.

Thanks

It looks like you're using this with a database besides MySQL. I've uploaded a patch. Could you test it?

I can merge the change if it solves the bug, so lets just wait for the test results to see if it does solve the issue.

PostgreSQL, among other DBs, does not support UNSIGNED. If you'd still like that tested, I can install this and PG for you to show that this fixes the bug.

Merged!

+1