Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 12-09-2007, 03:45 PM
Hex_legend Hex_legend is offline
 
Join Date: May 2007
Posts: 750
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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         
SundayDecember 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?
Reply With Quote
  #2  
Old 12-09-2007, 05:13 PM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #3  
Old 12-09-2007, 05:25 PM
Hex_legend Hex_legend is offline
 
Join Date: May 2007
Posts: 750
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #4  
Old 12-09-2007, 05:42 PM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #5  
Old 12-09-2007, 05:43 PM
Hex_legend Hex_legend is offline
 
Join Date: May 2007
Posts: 750
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #6  
Old 12-09-2007, 06:54 PM
WhaLberg's Avatar
WhaLberg WhaLberg is offline
 
Join Date: Nov 2006
Location: Dersaadet
Posts: 569
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

Code:
ALTER TABLE thread ADD story_outline TEXT NOT NULL
Reply With Quote
  #7  
Old 12-09-2007, 07:55 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Hex_legend View Post
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 ?
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 02:25 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.19810 seconds
  • Memory Usage 2,241KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (2)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete