vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   phpMyadmin query help (https://vborg.vbsupport.ru/showthread.php?t=294150)

betts02 01-20-2013 12:59 PM

phpMyadmin query help
 
OK i have a mod that i need help with in phpMyadmin area

The author sent me this:

Quote:

Then go to phpMyAdmin and execute following query:

Code:

ALTER TABLE vbclan_games ADD forumsbanner VARCHAR(50) NOT NULL DEFAULT '' AFTER banner
If you use a different prefix than vb for the database tables, you'll have to replace it first.
I use forums as my prefix so anyone help me on how to do this ?

I tried altering the "vbclan_games" to "forumsclan_games" but no luck

I am stuck at the BOLD bit in the quote

Simon Lloyd 01-20-2013 01:27 PM

If you ARE running this in phpmyadmin then
PHP Code:

ALTER TABLE forumsclan_games ADD forumsbanner VARCHAR(50NOT NULL DEFAULT '' AFTER banner 

but first visit the table forumsclan_games then click the SQL tab then run the query.

is your prefix actually
forumsclan
or
forums_clan

betts02 01-20-2013 01:34 PM

Quote:

#1142 - ALTER command denied to user 'nextgen6'@'localhost' for table 'clan_games'
That is what i am getting back when i try to run the query mate

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

Its actually
_forum

I can execute the original code but the alteration on the mod does not work, It does not post the game banner , It just posts the variable as text

Simon Lloyd 01-20-2013 02:13 PM

Then your query should be
PHP Code:

ALTER TABLE _forumclan_games ADD forumsbanner VARCHAR(50NOT NULL DEFAULT '' AFTER banner 


betts02 01-20-2013 03:30 PM

Cheers for the help but that does not work either

I will have to wait for the coder to reply to me as its not working at all

Cheers for your help though mate

Simon Lloyd 01-20-2013 03:35 PM

Did it at least add the new column for you?

kh99 01-20-2013 03:37 PM

Quote:

#1142 - ALTER command denied to user 'nextgen6'@'localhost' for table 'clan_games'

This error is showing that the problem is permissions and not the query syntax. Do you have access to the Execute SQL Query function under the Maintenance menu in the admincp? If so you could try it there. If not, then you need to talk to someone who can adjust the permissions (if that isn't you).

Edit: oh, well if you got the column added (as you mentioned below) then maybe it was the syntax, and it was misunderstanding what you wanted to change. never mind.

betts02 01-20-2013 03:48 PM

Quote:

Originally Posted by Simon Lloyd (Post 2398195)
Did it at least add the new column for you?

Yes it added the column which i did before but as it was not working still i assumed i was not doing something correctly which is why i asked here

It could be the files i uploaded or it simply does not work correctly
I will have to wait for a reply from the author of this mod


All times are GMT. The time now is 09:13 AM.

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.01039 seconds
  • Memory Usage 1,731KB
  • 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)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