"You are not authorized to execute SQL queries"

[Dave234]

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?

[snakes1100]

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.

<?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;

[Dave234]

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.....

[snakes1100]

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.

[ForceHSS]

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

[Dave234]

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:

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......

[ForceHSS]

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

[snakes1100]

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

[Dave234]

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

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????

[snakes1100]

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.