you don't understand me

[sound33]

Hey everyone and staff

I have autism and OCD thats means i have a hard time learning how to add ing mysql databases the manual way okay

I do not want to break my hosting account at all

because my parents pay alot of money to keep my hosting account online

and i do not want to break it okay

thanks for your time

[BirdOPrey5]

There are things you can do to lessen the risk of damaging your forum, but when using custom modifications that will ALWAYS be a risk.

1st) Make sure you are doing regular backups of your site and database. Some hosts will do this for you, you should contact them and see if they are. Even they are you should also do a backup to your home computer just in case but maybe not as often as otherwise.

2nd) Setup your "test forum." Your vBulletin license allows you to install a second test forum for the purpose of testing mods and debugging software. You just have to password protect this forum from the public. All changes you would make to your live forum you would make to your test forum first to make sure it works.

3rd) Do not install any untested/unproven mods. When you come across a mod thread ALWAYS read it IN FULL- yes even if it is VERY long. It is the only way to know what problems other people may be having and if fixes are available. Don't be the first to install any new mod- even the best coders can make a mistake and release buggy software- make sure a product has a number of installs and positive comments before even attempting to install.

Follow this advice and you'll be a lot less likely to break your forum, and if you do, you *should* have a backup.

[borbole]

Originally Posted by sound33

Hey everyone and staff

I have autism and OCD thats means i have a hard time learning how to add ing mysql databases the manual way okay

I do not want to break my hosting account at all

because my parents pay alot of money to keep my hosting account online

and i do not want to break it okay

thanks for your time

Adding mysql databases manually will not break your forum or your hosting account at all because they are totally unrelated. When you create a mysql database for your forum that means that your forum is not installed yet so it can''t break something that does not exist.

If you want to create a mysql database for something unrelated to the forum you can do so at the Mysql section in your cPanel. If you are uncofortable with this then ask your host to set them up and pass you the details.

If you will need to edit a database that holds data for your forum or other scripts, then as mentioned above, make a backup of it prior to applying those edits.

[Digital Jedi]

And keep in mind that if your patient enough to wait on us for an answer (sometimes we take a while), we're more than willing to help you with problems you run into. We have a number of members on this forum who's first language is not English, and in some cases people are using Google Translate to communicate with us, which is not the most accurate method of translating in the world. If we can work across language barriers, we can pretty much work across any kind of disability.

[sound33]

Hey staff

these are the error messages that come up when i use this newer version of vbplaza


Database error in vBulletin 4.1.3:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '12317183',
`genericpermissions` = '1579685063',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '137215',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '191',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '251767',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535',
`dbtech_vbshoutpermissions` = '0',
`vbbux_perdailyvisit` = '',
`vbbux_perreferral` = '',
`vbbux_perbirthday` = '',
`vbbux_perprofileview` = '',
`vbbux_perthreadview` = '',
`vbbux_pernewthread` = '',
`vbbux_pernewpost` = '',
`vbbux_pernewpicturepost` = '',
`vbbux_pernewsocialpost` = '',
`vbbux_pernewvisitpost` = '',
`vbbux_peralbumview` = '',
`vbbux_peralbumpicview` = '',
`vbbux_perstickythread` = '',
`vbbux_perpostedchar` = '',
`vbbux_perpostedcharmax` = '',
`vbbux_pergoodrep` = '',
`vbbux_perbadrep` = '',
`vbbux_pernewpoll` = '',
`vbbux_perpollvote` = '',
`vbbux_perthreadrated` = '',
`vbbux_percaladded` = '',
`vbbux_perprofpicadd` = '',
`vbbux_perprofpicsub` = '',
`vbbux_peralbumpicadd` = '',
`vbbux_peralbumpicsub` = '',
`vbplaza_admin_permissions` = '0',
`vbplaza_settings` = '0',
`vbbux_paycheck` = '',
`vbplaza_discount` = '',
`vbplaza_secondarycost` = '',
`vbplaza_primarycost` = ''
WHERE usergroupid=2;

MySQL Error : Unknown column 'vbbux_perdailyvisit' in 'field list'
Error Number : 1054
Request Date : Monday, September 12th 2011 @ 10:35:04 PM
Error Date : Monday, September 12th 2011 @ 10:35:04 PM
Script : http://bobbyautodj.tbrnhost.com/foru....php?do=update
Referrer : http://bobbyautodj.tbrnhost.com/foru...&usergroupid=2
IP Address : N/A
Username : saucerfoot
Classname : vB_Database
MySQL Version : 5.0.92-community








Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM vbplaza_item ORDER BY categoryid, displayorder;

MySQL Error : Table 'saucerfo_vb4.vbplaza_item' doesn't exist
Error Number : 1146
Request Date : Monday, September 12th 2011 @ 10:36:22 PM
Error Date : Monday, September 12th 2011 @ 10:36:22 PM
Script : http://bobbyautodj.tbrnhost.com/foru...plaza_item.php
Referrer : http://bobbyautodj.tbrnhost.com/foru...dex.php?do=nav
IP Address : N/A
Username : saucerfoot
Classname : vB_Database
MySQL Version : 5.0.92-community









Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM vbplaza_category ORDER BY displayorder;

MySQL Error : Table 'saucerfo_vb4.vbplaza_category' doesn't exist
Error Number : 1146
Request Date : Monday, September 12th 2011 @ 10:36:59 PM
Error Date : Monday, September 12th 2011 @ 10:36:59 PM
Script : http://bobbyautodj.tbrnhost.com/foru...a_category.php
Referrer : http://bobbyautodj.tbrnhost.com/foru...dex.php?do=nav
IP Address : N/A
Username : saucerfoot
Classname : vB_Database
MySQL Version : 5.0.92-community








Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM vbplaza_gift_item ORDER BY displayorder;

MySQL Error : Table 'saucerfo_vb4.vbplaza_gift_item' doesn't exist
Error Number : 1146
Request Date : Monday, September 12th 2011 @ 10:37:59 PM
Error Date : Monday, September 12th 2011 @ 10:37:59 PM
Script : http://bobbyautodj.tbrnhost.com/foru...plaza_gift.php
Referrer : http://bobbyautodj.tbrnhost.com/foru...dex.php?do=nav
IP Address : N/A
Username : saucerfoot
Classname : vB_Database
MySQL Version : 5.0.92-community








Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM vbplaza_lottery ORDER BY displayorder;

MySQL Error : Table 'saucerfo_vb4.vbplaza_lottery' doesn't exist
Error Number : 1146
Request Date : Monday, September 12th 2011 @ 10:38:46 PM
Error Date : Monday, September 12th 2011 @ 10:38:47 PM
Script : http://bobbyautodj.tbrnhost.com/foru...za_lottery.php
Referrer : http://bobbyautodj.tbrnhost.com/foru...dex.php?do=nav
IP Address : N/A
Username : saucerfoot
Classname : vB_Database
MySQL Version : 5.0.92-community








Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM vbplaza_purchase_item ORDER BY displayorder;

MySQL Error : Table 'saucerfo_vb4.vbplaza_purchase_item' doesn't exist
Error Number : 1146
Request Date : Monday, September 12th 2011 @ 10:39:16 PM
Error Date : Monday, September 12th 2011 @ 10:39:16 PM
Script : http://bobbyautodj.tbrnhost.com/foru...ase.php?do=add
Referrer : http://bobbyautodj.tbrnhost.com/foru...dex.php?do=nav
IP Address : N/A
Username : saucerfoot
Classname : vB_Database
MySQL Version : 5.0.92-community











Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM vbplaza_ribbon_item ORDER BY displayorder;

MySQL Error : Table 'saucerfo_vb4.vbplaza_ribbon_item' doesn't exist
Error Number : 1146
Request Date : Monday, September 12th 2011 @ 10:39:46 PM
Error Date : Monday, September 12th 2011 @ 10:39:46 PM
Script : http://bobbyautodj.tbrnhost.com/foru...aza_ribbon.php
Referrer : http://bobbyautodj.tbrnhost.com/foru...dex.php?do=nav
IP Address : n/a
Username : saucerfoot
Classname : vB_Database
MySQL Version : 5.0.92-community









Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM vbplaza_track_item ORDER BY displayorder;

MySQL Error : Table 'saucerfo_vb4.vbplaza_track_item' doesn't exist
Error Number : 1146
Request Date : Monday, September 12th 2011 @ 10:40:23 PM
Error Date : Monday, September 12th 2011 @ 10:40:23 PM
Script : http://bobbyautodj.tbrnhost.com/foru...laza_track.php
Referrer : http://bobbyautodj.tbrnhost.com/foru...dex.php?do=nav
IP Address : N/A
Username : saucerfoot
Classname : vB_Database
MySQL Version : 5.0.92-community









Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM vbplaza_item ORDER BY itemid;

MySQL Error : Table 'saucerfo_vb4.vbplaza_item' doesn't exist
Error Number : 1146
Request Date : Monday, September 12th 2011 @ 10:40:53 PM
Error Date : Monday, September 12th 2011 @ 10:40:53 PM
Script : http://bobbyautodj.tbrnhost.com/foru....php?do=verify
Referrer : http://bobbyautodj.tbrnhost.com/foru...dex.php?do=nav
IP Address : N/A
Username : saucerfoot
Classname : vB_Database
MySQL Version : 5.0.92-community


and those are all of the error messages

[Digital Jedi]

I'll try and answer your question, but I'll have to do in the vBPlaza thread, as per the forum rules. I'll post in the 4.x version of that thread.

[sound33]

Hey staff

I am very sad right now

because you guys won't help me to add in those missing tables for me

I tried doing it myself many times, but its to hard for me to do on my own

so can you please help me

thanks

[Digital Jedi]

They can't and shouldn't be added manually. Wouldn't be a good idea. The modification needs to add them during install. If it doesn't, someone with the time and expertise to work on the modification needs to address why an important function of the modification isn't working. Have you tried a fresh uninstall/reinstall? We should move any discussion of vBPlaza to it's respective thread.

[sound33]

Hey ditial Jedi

Yes i have tried a uninstall and renistall of that mod and the tables still did not get added for me at all

so what could be wrong then

[BirdOPrey5]

This discussion must continue in the mod thread.

Closing this thread.