vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   MySql Error? (https://vborg.vbsupport.ru/showthread.php?t=164752)

Hex_legend 12-09-2007 03:45 PM
MySql Error?
 
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 12-09-2007 05:13 PM
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 12-09-2007 05:25 PM
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 12-09-2007 05:42 PM
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 12-09-2007 05:43 PM
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 12-09-2007 06:54 PM
Run this query via phpMyAdmin or vB Maintenance -> Execute SQL Query:

Code:
ALTER TABLE thread ADD story_outline TEXT NOT NULL

Paul M 12-09-2007 07:55 PM
Quote:
Originally Posted by Hex_legend (Post 1398039)
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 ?


All times are GMT. The time now is 08:16 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01110 seconds
  • Memory Usage 1,752KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (2)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete