vb.org Archive - "You are not authorized to execute SQL queries"

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - "You are not authorized to execute SQL queries" (https://vborg.vbsupport.ru/showthread.php?t=287376)

Please help me. How can I do that? I am really dumb with this stuff, and after adding stuff all day to my website my brain is fried.

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

I don't know where my vbulletin.zip file is.

I do have another config.php file, but for my other site..... Could I use that?

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

Is it WordPad? All I did was "View/Edit" and I added the "1" for my userid, then I saved it on my desktop. Then I dragged it back over the config.php file in my ftp...... Did I do something wrong there?

Fill in your database details, then upload the file via ftp, overwriting the old one.

Im not sure why your dragging and dropping files, but i would edit directly from the server, then resave it to the server.

Code:

<?php

$config['Database']['dbtype'] = 'mysql';

$config['Database']['dbname'] = '';

$config['Database']['tableprefix'] = '';

$config['Database']['technicalemail'] = '';

$config['Database']['force_sql_mode'] = false;

$config['MasterServer']['servername'] = 'localhost';

$config['MasterServer']['port'] = 3306;

$config['MasterServer']['username'] = '';

$config['MasterServer']['password'] = '';

$config['MasterServer']['usepconnect'] = 0;

$config['SlaveServer']['servername'] = '';

$config['SlaveServer']['port'] = 3306;

$config['SlaveServer']['username'] = '';

$config['SlaveServer']['password'] = '';

$config['SlaveServer']['usepconnect'] = 0;

$config['Misc']['admincpdir'] = 'admincp';

$config['Misc']['modcpdir'] = 'modcp';

$config['Misc']['cookieprefix'] = 'bb';

$config['Misc']['forumpath'] = '';

$config['SpecialUsers']['canviewadminlog'] = '1';

$config['SpecialUsers']['canpruneadminlog'] = '1';

$config['SpecialUsers']['canrunqueries'] = '1';

$config['SpecialUsers']['undeletableusers'] = '1';

$config['SpecialUsers']['superadministrators'] = '1';

//$config['Datastore']['class'] = 'vB_Datastore_XCache';

//$config['Datastore']['prefix'] = 'at_';



/*

$config['Datastore']['class'] = 'vB_Datastore_Memcached';

$i = 0;

// First Server

$i++;

$config['Misc']['memcacheserver'][$i]                        = '127.0.0.1';

$config['Misc']['memcacheport'][$i]                                = 11211;

$config['Misc']['memcachepersistent'][$i]                        = true;

$config['Misc']['memcacheweight'][$i]                        = 1;

$config['Misc']['memcachetimeout'][$i]                        = 1;

$config['Misc']['memcacheretry_interval'][$i]                = 15;

*/



// $config['Mysqli']['charset'] = 'utf8';



$config['Mysqli']['ini_file'] = '';

$config['Misc']['maxwidth'] = 2592;

$config['Misc']['maxheight'] = 1944;

Please bear with me -- I just want to confirm each step of what I must do:

1. I right-click the "config.php" file in my ftp, and choose "View/Edit"
2. I delete everything, and replace it with what you posted.
3. I add my usernames and passwords that I'd "xxxxxx"ed out in my previous post.
4. Then what? How do I save this?

Please bear with me as this stuff is like a foreign language to me, and I'm terrified of losing my website contents.....

Most ftp programs like flashfxp, cuteftp & filezilla, let you use the standard "ctl + s" to save, it will reupload the file for you once its prompted to save.

I have my program as follows:
1. Connect via FlashFXP
2. Right click & select edit
3. FlashFXP opens Edit++ for me, as its my defautl editor
4. ctl +s & its resaved to the server.

I would also suggest that your careful with what editor you use, notepad is fine. Do not use a built in editor such as the one provided thru for example Cpanel, as it will add white spacing to the end of the file & corrupt the config file.

use notepad ++ to edit the config but first download a new unedited one first. If you give me the info needed for the config will do one for you

Mine is WordPad.

Actually, when I right-click and do "View/Edit" on the config.php file in my ftp, a window pops up that says:

Quote:

The selected file is already being edited: config.php
Action to perform:
x Reopen local file
x Discard local file then download and edit file anew

Which should I choose? I don't have my WordPad open at all. I do have a file saved to my desktop, though......... does that mean the config.php file in my ftp is open?

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

How can I change it so that it opens in Notepad? I have Notepad on my computer, but config.php automatically opens in WordPad......

you need to download the config to your desktop first then edit it with the program i posted above

discard the local & redo it, as far as changing your default editor, you would need to consult the help section of your ftp program.

I just went into my ftp and did the following to change the editor from WordPad to NotePad, but it did not work:

Edit > Settings... > File Editing > Default Editor: (changed it from "Do not use default editor" to "Use custom editor:", from which point I browsed for Notepad here C:\Windows\system32\notepad.exe)

I clicked OK.

Then I right-clicked on the config.php file and chose "View/Edit", and when the window

Quote:

The selected file is already being edited: config.php
Action to perform:
x Reopen local file
x Discard local file then download and edit file anew

popped up, I chose "Discard local file then download and edit file anew".

It opened the file again in WordPad...............

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

Please can someone walk me through this? I'm really worried about losing the content of my website that I'd spent all day doing today......

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

Ok, you know what? This is ridiculous. I just downloaded Notepad again.

I clicked that I wanted it to be the default editor.

And when I click "View/Edit" the config.php file, it ****STILL**** opens in WordPad.

Can I just copy and Paste Special as Values (no formatting) from WordPad into Notepad? Or is the text ***already*** messed up the moment it is opened in WordPad????

This is very frustrating!!! What is the point of having WordPad if it just messes up text????

Restart your ftp program after changing the editor.

As i stated earlier, when it asked to keep or discard the old local copy, discard it.

X vBulletin 3.8.12 by vBS Debug 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_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01096 seconds Memory Usage 1,751KB 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_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: