![]() |
anybody tried this on 3.0.3?
|
Quote:
|
Is there a fix for the background problem or a way to change the colour of the text?
|
Quote:
So If someone that is MYSQL talented could help us add these frases manually in th ADMINCP by properly wording and formatting the SQL table additions, this would be all that is left to get my clients Shout Box working. Evething is showing on the page, but the Shot Box iss empty, I believe its due to PERMISSIONS, I cannot edit them in the ADMINPC because there is nothing under USERGROUPS, and it just happens that this is where the install script errored. I removed 2 table edits from the install script to get it to complete the install as instructed above. Here is the installs table edits that I had to remove in order for the install script to complete. ALTER TABLE . TABLE_PREFIX . usergroup ADD shoutboxpermissions INT UNSIGNED NOT NULL DEFAULT '0' AFTER forumpermissions and "ALTER TABLE " . TABLE_PREFIX . "language ADD phrasegroup_shoutbox MEDIUMTEXT NOT NULL, ADD phrasegroup_shoutmanager MEDIUMTEXT NOT NULL", I need these typed so I can cut and paste it into the ADMINCP's Execute SQL Query box. This should add the Shout Box in my user groups, so I may change the permissions, so It can be viewed. Am I making sense?? LOL |
Quote:
|
Yes, went through them at least 3 times.
I try running these commands in MYSQL and keep receiving errors ALTER TABLE . TABLE_PREFIX . usergroup ADD shoutboxpermissions INT UNSIGNED NOT NULL DEFAULT '0' AFTER forumpermissions gives error "An error occurred while attempting to execute your query. The following information was returned. error number: 1064 error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '. "language DROP phrasegroup_shoutbox, DROP phrasegroup_shoutma" and "ALTER TABLE " . TABLE_PREFIX . "language ADD phrasegroup_shoutbox MEDIUMTEXT NOT NULL, ADD phrasegroup_shoutmanager MEDIUMTEXT NOT NULL", gives error "An error occurred while attempting to execute your query. The following information was returned. error number: 1064 error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'language INSERT phrasegroup_shoutbox MEDIUMTEXT NOT NULL, INSER" and its Shout Box Permissions that I'm have problems with "my best guess anyways" I will go through the manual file edits once again tonight, never know might have missed something :) |
O.K. Went through each file mod again, still blank Shout Box, which I believe is due to, no permissions. Also get this error when I click on the SHOUT BOX link on top left of box its self.
"you do not have permission to access this page. This could be due to one of several reasons: Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system? If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation." Now I have set permissions in the Administrator Permissions Manager to YES, only after fixing the errors in the install in the file adminpermissions.php. His install states to put " 'canadmincron' => $vbphrase['can_administer_cron'], 'canadminshouts' => $vbphrase['can_administer_shouts'] 'canadminmaintain' => $vbphrase['can_run_maintenance']," But it should look like " 'canadmincron' => $vbphrase['can_administer_cron'], 'canadminshouts' => $vbphrase['can_administer_shouts'], 'canadminmaintain' => $vbphrase['can_run_maintenance']," Note the missing "," after the "]" Now like I have been suggesting, I believe the lack of permissions and the ability to edit them in the user Group Manager "not showing anything that says Shout Box" is due to the Install Script erroring out at the 2 areas mentioned above. and If I could get somebody to write the edits with the proper SYNTAX so I can install them manually without errors, this should get "might" this darn thing working. Thanks In advance. |
Maybe I'm off in left field, or just mis-understood, but could the TABLES that the install errors on, be keeping the ShoutBox fields from showing up in the Group Permissions?
anyone??? |
ok part of your problem is that you can't manually add that query as written "table prefix" is catchall relating to whatever your table prefix is. Run this instead
ALTER TABLE usergroup ADD shoutboxpermissions INT UNSIGNED NOT NULL DEFAULT '0' AFTER forumpermissions and ALTER TABLE language ADD phrasegroup_shoutbox MEDIUMTEXT NOT NULL ALTER TABLE language ADD phrasegroup_shoutmanager MEDIUMTEXT NOT NULL Now, if your tables DO have a prefix...you must add it to the table name ie prefix.language or whatever it is you use. Most probably don't have a specific prefix and just use the server default..so you should be ok to run the above |
First off, THANK YOU for responding. :o)
I ran the Queries, and it looks like they are already installed. Quote:
From the above errors, I have to assume that the tables are correct, or should I remove and re-install them? I'm at a loss. |
Quote:
Same Here very strange i also had to set permission to NO update then back to YES and it all works fine now :ermm: :ermm: |
I have this hack installed...and I do not see a place where it allows for Admins to see the shouts. This really sucks because they should be able to no problem
|
You need to edit your "index.php" to see the shoutbox shouts.
|
I just made my Admins primary and then registered usergroup an extra it worked out !
|
How you go about uninstalling this?
|
O.K. I know when to say enoughs enough, no help from the coder, I've removed this puppy!
|
wow
i guess i did wrong installing this hack, but i read the thread after i installed it... well it works fine, and i'm going to keep it but need to touch a thing or two how i can set a font size of the time? [30-09-2004 03:32 AM] i want to make it smaller |
Invalid SQL:
SELECT s.*, u.username FROM shout s LEFT JOIN user u ON (u.userid = s.userid) ORDER BY dateline , shoutid LIMIT What this mean? |
How do you uninstall this hack safely?
|
the IE started crashing, may this hack be the reason?
the weird is that it crashes only when i load the url with www. in front |
Quote:
|
I jsut downlaoded the installer. When I installed the first step iand click continue, nothing ever happens...
|
Quote:
what i can use instaed of iframe? |
Hi,
I get the following when I install this hack, I know this error message has been posted before, but there has been no direct reply to the fix for the error message, does anyone know of a fix? thanks taffy Database error in vBulletin 3.0.3: Invalid SQL: UPDATE usergroup SET ### UPDATE QUERY GENERATED BY fetch_query_sql() ### title = 'Administrators', description = '', usertitle = 'Administrator', opentag = '', closetag = '', passwordexpires = '180', passwordhistory = '360', attachlimit = '0', avatarmaxwidth = '80', avatarmaxheight = '80', avatarmaxsize = '20000', profilepicmaxwidth = '100', profilepicmaxheight = '100', profilepicmaxsize = '65535', pmquota = '200', pmsendmax = '5', canaddshout = '1', candropshout = '1', candropothershout = '1', caneditshout = '1', caneditothershout = '1', canreadshouts = '1', forumpermissions = '393215', pmpermissions = '3', calendarpermissions = '31', wolpermissions = '31', adminpermissions = '3', genericpermissions = '4194239', genericoptions = '31', hivepermissions = '15', petzpermissions = '1', arcadepermissions = '31' WHERE usergroupid=6 mysql error: Unknown column 'canaddshout' in 'field list' mysql error number: 1054 Date: Tuesday 09th of November 2004 02:23:55 AM Script: http://mydomain.uk/vbforum/admincp/usergroup.php Referer: http://mydomain.uk/vbforum/admincp/u...&usergroupid=6 Username: admin IP Address: 84.*.*.* |
Quote:
|
Thanks. I'll test it.
|
Hi,
I was wondering if anyone has any answers to the above problem? It is effecting me making any changes in the usergroups, so I really need an answer if possible. otherwise I will attempt to uninstall it because it is not supported! thanks taffy |
I figured out why I can't see anything in the ADMINCP. Its due to a failed install.
So I'm having to manually install phrases, and MYSQL Queries. Now I've managed to install the phrases, but am really lost when it comes to the Queries! Would someone please be so kind as to take this text and make the queries in it a cut and paste for MYSQL? PHP Code:
|
Hi,
It looks as if I will have uninstll this hack! Are the steps bitg mentions all the steps you have to take to uninstall? I am very wary about going into my database deleting items, if I delete everything else will it matter that these are still in the database? I plan to install a different shoutbox, am I going to get a problem by leaving the previous shout table there? Thanks taffy Quote:
|
Quote:
Please |
Hi,
I have uninstalled this hack, but I am left with a number of templates (below) how can I delete them? Revert is greyed out! shoutbox_archive shoutbox_archive_message shoutbox_archive_message_me shoutbox_archive_topbit shoutbox_editmessage shoutbox_iframe shoutbox_main shoutbox_main_message shoutbox_main_message_me shoutbox_newmessage shoutbox_newmessage_refresh shoutbox_shouterror |
I've properly installed this okay, cept for one thing. It's not a problem as such, but any help would be appreciated :D
You know the iFrame where the text appears? Because of the skin I use, the background for the iFrame uses the background for the skin, which is dark and unreadable. Does anyone know where it is that I can change the background colour to white? |
Quote:
I'm really at a loss, I hit a deer tonight with my brand new car, I have the family's thing to do tomorrow, so getting my clients site up again soon is going to be tought to say the least. Specially since I havn't a clue what to do now. But If some nice coder who knows databases, could PM me I would Gladly let some of my PayPal money slide out of my account to theirs. and then I will find the answer your looking for and post it here. |
True Smiles,
I have managed to get the board back up by updating VB, I will have to reinstall all the Mods. When I get to the ShoutBox, I'll see if I can't answer your question. |
Sorry, I can't get this mod to install properly, I will not be able to help you on this one.
|
Quote:
|
Quote:
|
This is one of the easiest hack I ever installed. Since I read a couple of complaints about the iframe, I harcoded it in forumhome and it's fine, placed the validate javascript in the <head>, and changed the redirect back to the forum home... looks good. I made it display only one shout, but that could easily be changed into any amount.
|
Quote:
|
he just took the code im guessing and went about putting it in the FORUMHOME template and then took the redirection and put it in the head area
|
All times are GMT. The time now is 09:40 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 | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|