MySql Error?

[Hex_legend]

I am trying to make my own modification that allows you to write your own story and publish it to the website,

I have most of it done now, but I can't get it to submit a story or delete the product as it comes back with Database Error.

Here is my code in the XML - can anyone show me what I've done wrong?

I'm a complete newbie when it comes to mods.

PHP Code:

<codes>
        <code version="1.0">
            <installcode><![CDATA[$db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD enable_story TINYINT( 1 ) NOT NULL");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "thread ADD (story_authorreal mediumtext NOT NULL DEFAULT '')");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "thread ADD (story_outline mediumtext NOT NULL DEFAULT '')");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "thread ADD (story_category mediumtext NOT NULL DEFAULT '')");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "thread ADD (story_age mediumtext NOT NULL DEFAULT '')");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "thread ADD (story_thanksto mediumtext NOT NULL DEFAULT '')");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "thread ADD (story_homepage mediumtext NOT NULL DEFAULT '')");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "thread ADD (story_steps MEDIUMTEXT NOT NULL DEFAULT '')");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD (story_stats INT(5) NOT NULL DEFAULT '0')");]]></installcode>
            <uninstallcode><![CDATA[$db->query_write("ALTER TABLE " . TABLE_PREFIX . "thread DROP story_authorreal");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "thread DROP story_outline");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "thread DROP story_category");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "thread DROP story_age");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "thread DROP story_thanksto");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "thread DROP story_homepage");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "thread DROP story_steps");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user DROP story_stats");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum DROP enable_story");]]></uninstallcode>
        </code>
    </codes> 


This is the database error:

PHP Code:

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE thread SET story_outline = 'test', story_age = '18', story_category = 'test', story_thanksto = 'myself', story_authorreal = 'Leigh', story_homepage = '', story_content = 'testing the story mode to see if it works' WHERE threadid = '6';

MySQL Error  : Unknown column 'story_outline' in 'field list'
Error Number : 1054
Date         : Sunday, December 9th 2007 @ 11:44:49 AM
Script       : http://xxxxxxxxxx/demo/newthread.php?do=postthread&f=4
Referrer     : http://xxxxxxxx/demo/newthread.php?do=postthread&f=4
IP Address   : 62.136.56.51
Username     : admin
Classname    : vb_database 


Can anyone see what I've done wrong?

[Opserty]

Run your install code and then check your database to see it if worked. It sounds like your install code didn't work or something.

[Hex_legend]

Well it runs on the site, but won't submit the data.
I don't know what else to do as I am new to coding, I got this far but that's about it and I am now at a dead end, so would appreciate anyone who could help me with this.

[Opserty]

MySQL Error : Unknown column 'story_outline' in 'field list'

It can't find the column, so I'm guessing it hasn't been added to the table.

[Hex_legend]

I've added you on msn, my address is always.alternative@hotmail.com

Any chance we could chat on there?

--------------- Added [DATE]1197230578[/DATE] at [TIME]1197230578[/TIME] ---------------

Can anyone look at the code and provide me with some help on what i've done wrong and how to get the database to accpet it?

[WhaLberg]

Run this query via phpMyAdmin or vB Maintenance -> Execute SQL Query:

ALTER TABLE thread ADD story_outline TEXT NOT NULL

[Paul M]

Originally Posted by Hex_legend

Can anyone look at the code and provide me with some help on what i've done wrong and how to get the database to accpet it?

What have you actually done with the code ?