Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > RPG Integration Hack
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
SQL Errors. Details »»
SQL Errors.
Version: , by laeth laeth is offline
Developer Last Online: Aug 2010 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 02-26-2005 Last Update: Never Installs: 0
 
No support by the author.

Heya,

When I first ran the installer file I got a SQL error (which I stupidly didnt store somewhere).

Anyway I then decided to use the delete functions. This is where I got the:

Invalid SQL: ALTER TABLE vb3_userfield DROP field;
mysql error: Can't DROP 'field'; check that column/key exists

mysql error number: 1091


So I looked on the forums here and found a post saying too add two lines of code. One before the data query and one after. I did this, and now I get the error.

Database error in vBulletin 3.0.3:

Invalid SQL: CREATE TABLE `vb3_rpg_lottery` (
`lotteryid` int(5) NOT NULL auto_increment,
`lotteryname` varchar(20) NOT NULL default '',
`lotterym` varchar(50) NOT NULL default '',
`prize` int(10) NOT NULL default '0',
`dateset` varchar(35) NOT NULL default '',
`dateend` varchar(35) NOT NULL default '',
`cost` int(6) NOT NULL default '0',
`sold` int(5) NOT NULL default '0',
`active` int(2) NOT NULL default '0',
`editing` int(5) NOT NULL default '',
PRIMARY KEY (`lotteryid`,`lotteryid`)
) TYPE=MyISAM;
mysql error: Duplicate column name 'lotteryid'

mysql error number: 1060


When I run the delete option again, I dont get any errors anymore. But this error keeps popping up whenever I try and install the tables.

I have looked inside phpmyadmin for lotteryid, and I get four matches within the vb3_templates table.

Any help would be cool, not sure what to do. Can I just ignore it?

Thanks.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 02-26-2005, 09:54 PM
Revan's Avatar
Revan Revan is offline
 
Join Date: Jan 2004
Location: Norway
Posts: 1,671
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

<a href="https://vborg.vbsupport.ru/showpost.php?p=614501&postcount=8" target="_blank">https://vborg.vbsupport.ru/showp...01&postcount=8</a>
This file might help. Try running install with that one. It SHOULD amend to the installation, provided its not a table half added.
If this doesn't solve your problem, then you have to manually edit the profilefield table, drop the RPG related stuff in there, and manually create the field through the ACP.
Reply With Quote
  #3  
Old 02-26-2005, 10:10 PM
laeth laeth is offline
 
Join Date: Aug 2004
Posts: 40
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Unfortunatly that didnt do the trick. I got the same error.

What do you mean add the field manually through the ACP?

Thanks again.

EDIT:Nvm, I managed to get the tables to work.

Now I just need to figure out the lank posts problem. Also, my post bit info doesnt seem to want to update. The extended rpg stats works, but the post bit doesnt. Any ideas?


EDIT2: Well everything seems to be working now. The reason I was getting blank posts afaik is because the tables were not working. Same with the postbit.

Thanks dude.
Reply With Quote
Reply


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 05:29 AM.


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.03725 seconds
  • Memory Usage 2,207KB
  • Queries Executed 16 (?)
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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (2)postbit
  • (3)postbit_onlinestatus
  • (3)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