vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Shoutbox Hack 1.04b (https://vborg.vbsupport.ru/showthread.php?t=68861)

Link14716 09-12-2004 06:23 PM

Alright.

STOP posting these errors like "Warning: halt(): Unable to access ./includes/functions_log_error.php in /home/www/nc0801/html/vbulletin/includes/db_mysql.php on line 389". I do not care about that, it just means there is a MySQL error below. If you want support, I NEED to know the MySQL error. Period.

Second, to everyone getting those errors starting with "Warning: readdir(): supplied argument is not a valid Directory resource in /htdocs/www/forum/install/hack_install.php on line 22". I need more information. Web server (probably apache) and version and PHP version. Otherwise it'll be hard for me to fix this since I cannot reproduce this error, and the functions used dates back to PHP3.

Everyone requesting features: I'll get to you when I have time.

alzibub 09-12-2004 09:21 PM

Quote:

Originally Posted by alzibub
Hi,

I originally had some question on Phrases not appearing - but for some strange reason they just appeared - 3 hours after I posted this - dont ask !

I do have one issue - I noticed new shouts arent appearing on the forum homepage - but they show under shout.php..

Relatively clean vb3.0.3 install.
Full install rather than Upgrade

As far as install - got as far as installing templates click done and then got SQL error for the final step - someone mentioned this wasn't too important as it was just the final success page.

Thanks for a great hack !

Hi,

Just wanted to add some more details for you.
The issue is with the iframe version of the shoutbox - because if you switch off the iframe you can see the posts.

The last time I had this issue was after upgrading to 1.02 of the hack - Link14716 fixed the issue then released 1.03 - his post on VB was as follows..

https://vborg.vbsupport.ru/showpost....&postcount=257

Not sure what was meant or if it is any help in this case or not.

Thanks in advance

TruthElixirX 09-13-2004 01:27 AM

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE vb3_user SET uttpoints=uttpoints+.25 WHERE userid='1'
mysql error: Unknown column 'uttpoints' in 'field list'

mysql error number: 1054


Umm....*Confused* My shoutbox doesn't appear on forum home. I can type in forums/shoutbox.php and it'll take me to it. Once I'm there I can type in a shout but it gives me that error up there.

I tried re-installing and got this on the final install page:


// Settings

$settinggroup['shoutbox']['phrase'] = 'Shoutbox Settings';
$settinggroup['shoutbox']['displayorder'] = '560';

$setting['shoutbox_shoutonforumhome']['titlephrase'] = 'Show an Input Box/Textarea on Forumhome?';
$setting['shoutbox_shoutonforumhome']['descphrase'] = 'With this option, you can show a textarea or an input box on forumhome allowing users to shout without going to into the shoutbox first.';
$setting['shoutbox_shoutonforumhome']['grouptitle'] = 'shoutbox';
$setting['shoutbox_shoutonforumhome']['value'] = 'input';
$setting['shoutbox_shoutonforumhome']['defaultvalue'] = 'Input';
$setting['shoutbox_shoutonforumhome']['optioncode'] = '<span class=\"smallfont\" style=\"white-space:nowrap\">
<label for=\"sofh1\"><input type=\"radio\" name=\"setting[$settingid]\" id=\"sofh1\" value=\"none\" tabindex=\"1\"" . iif($setting[\'value\'] == none, \' checked=\"checked\"\') . " />None</label><br />
<label for=\"sofh2\"><input type=\"radio\" name=\"setting[$settingid]\" id=\"sofh2\" value=\"input\" tabindex=\"2\"" . iif($setting[\'value\'] == input, \' checked=\"checked\"\') . " />Input Box</label><br />
<label for=\"sofh3\"><input type=\"radio\" name=\"setting[$settingid]\" id=\"sofh3\" value=\"textarea\" tabindex=\"3\"" . iif($setting[\'value\'] == textarea, \' checked=\"checked\"\') . " />Textarea</label><br />
</span>';
$setting['shoutbox_shoutonforumhome']['displayorder'] = '24';

$setting['shoutbox_hierarchymode']['titlephrase'] = 'Hierarchy Mode?';
$setting['shoutbox_hierarchymode']['descphrase'] = 'If you set this to option #1, then users <b>can</b> edit other users with the same hierarchy rank (default). If you set it to option #2, then users <b>can not</b> edit users with the same hierarchy rank.';
$setting['shoutbox_hierarchymode']['grouptitle'] = 'shoutbox';
$setting['shoutbox_hierarchymode']['value'] = '1';
$setting['shoutbox_hierarchymode']['defaultvalue'] = '1';
$setting['shoutbox_hierarchymode']['optioncode'] = '<span class=\"smallfont\" style=\"white-space:nowrap\">
<label for=\"hierarchy1\"><input type=\"radio\" name=\"setting[$settingid]\" id=\"hierarchy1\" value=\"1\" tabindex=\"1\"" . iif($setting[\'value\'] == 1, \' checked=\"checked\"\') . " />#1</label><br />
<label for=\"hierarchy2\"><input type=\"radio\" name=\"setting[$settingid]\" id=\"hierarchy2\" value=\"2\" tabindex=\"2\"" . iif($setting[\'value\'] == 2, \' checked=\"checked\"\') . " />#2</label><br />
</span>';
$setting['shoutbox_hierarchymode']['displayorder'] = '23';

$setting['shoutbox_allowshoutsperpage']['titlephrase'] = 'Allow Users to Specify Shouts Per Page?';
$setting['shoutbox_allowshoutsperpage']['descphrase'] = 'Set this to \'yes\' if you want to allow your users to specify an amount of shouts to display per page.';
$setting['shoutbox_allowshoutsperpage']['grouptitle'] = 'shoutbox';
$setting['shoutbox_allowshoutsperpage']['value'] = '1';
$setting['shoutbox_allowshoutsperpage']['defaultvalue'] = '1';
$setting['shoutbox_allowshoutsperpage']['optioncode'] = 'yesno';
$setting['shoutbox_allowshoutsperpage']['displayorder'] = '15';

$setting['shoutbox_allowhtml']['titlephrase'] = 'Allow HTML in Shouts?';
$setting['shoutbox_allowhtml']['descphrase'] = 'Set this to \'yes\' to allow users to post HTML in their shouts. <i>STRONGLY NOT RECOMMENDED!</i>';
$setting['shoutbox_allowhtml']['grouptitle'] = 'shoutbox';
$setting['shoutbox_allowhtml']['value'] = '0';
$setting['shoutbox_allowhtml']['defaultvalue'] = '0';
$setting['shoutbox_allowhtml']['optioncode'] = 'yesno';
$setting['shoutbox_allowhtml']['displayorder'] = '16';

$setting['shoutbox_allowbbcode']['titlephrase'] = 'Allow BBCode in Shouts?';
$setting['shoutbox_allowbbcode']['descphrase'] = 'Set this to \'yes\' to allow users to post BBCode in their shouts.';
$setting['shoutbox_allowbbcode']['grouptitle'] = 'shoutbox';
$setting['shoutbox_allowbbcode']['value'] = '1';
$setting['shoutbox_allowbbcode']['defaultvalue'] = '1';
$setting['shoutbox_allowbbcode']['optioncode'] = 'yesno';
$setting['shoutbox_allowbbcode']['displayorder'] = '17';

$setting['shoutbox_allowimage']['titlephrase'] = 'Allow [img] Code in Shouts?';
$setting['shoutbox_allowimage']['descphrase'] = 'Set this to \'yes\' to allow users to use the [img] BBCode in their shouts.';
$setting['shoutbox_allowimage']['grouptitle'] = 'shoutbox';
$setting['shoutbox_allowimage']['value'] = '1';
$setting['shoutbox_allowimage']['defaultvalue'] = '1';
$setting['shoutbox_allowimage']['optioncode'] = 'yesno';
$setting['shoutbox_allowimage']['displayorder'] = '18';

$setting['shoutbox_allowsmilies']['titlephrase'] = 'Allow Smilies in Shouts?';
$setting['shoutbox_allowsmilies']['descphrase'] = 'Set this to \'yes\' to allow users to post smilies in their shouts.';
$setting['shoutbox_allowsmilies']['grouptitle'] = 'shoutbox';
$setting['shoutbox_allowsmilies']['value'] = '1';
$setting['shoutbox_allowsmilies']['defaultvalue'] = '1';
$setting['shoutbox_allowsmilies']['optioncode'] = 'yesno';
$setting['shoutbox_allowsmilies']['displayorder'] = '19';

$setting['shoutbox_showsmiliebox']['titlephrase'] = 'Show Smilies Box?';
$setting['shoutbox_showsmiliebox']['descphrase'] = 'For some boards, either the width of the main table is small, or the smilies are large. If you fall under one of those cases, you may disable the displaying of the smilies box here.';
$setting['shoutbox_showsmiliebox']['grouptitle'] = 'shoutbox';
$setting['shoutbox_showsmiliebox']['value'] = '0';
$setting['shoutbox_showsmiliebox']['defaultvalue'] = '1';
$setting['shoutbox_showsmiliebox']['optioncode'] = 'yesno';
$setting['shoutbox_showsmiliebox']['displayorder'] = '20';

$setting['shoutbox_showstats']['titlephrase'] = 'Show Stats?';
$setting['shoutbox_showstats']['descphrase'] = 'Set this to \'yes\' will show stats - total shouts, shouts that day, shouts in the last 24 hours, and shouts by that user.';
$setting['shoutbox_showstats']['grouptitle'] = 'shoutbox';
$setting['shoutbox_showstats']['value'] = '1';
$setting['shoutbox_showstats']['defaultvalue'] = '1';
$setting['shoutbox_showstats']['optioncode'] = 'yesno';
$setting['shoutbox_showstats']['displayorder'] = '21';

$setting['shoutbox_enablehierarchy']['titlephrase'] = 'Enable Hierarchy Permissions?';
$setting['shoutbox_enablehierarchy']['descphrase'] = 'Set this to \'yes\' to enable hierarchy permission setup for edt/delete/hard-delete. For example, by default, admins can edit/delete/hard-delete all shouts, super mods can delete all except for admins, and mods can edit all but super mods and admins <b>if</b> they have the &quot;edit/delete/hard-delete others&quot; permission.';
$setting['shoutbox_enablehierarchy']['grouptitle'] = 'shoutbox';
$setting['shoutbox_enablehierarchy']['value'] = '1';
$setting['shoutbox_enablehierarchy']['defaultvalue'] = '1';
$setting['shoutbox_enablehierarchy']['optioncode'] = 'yesno';
$setting['shoutbox_enablehierarchy']['displayorder'] = '22';

$setting['shoutbox_numberoftopshouters']['titlephrase'] = 'Number of Top Shouters?';
$setting['shoutbox_numberoftopshouters']['descphrase'] = 'Set the number of top shouters to show in the shoutbox, if the option to show them is enabled.';
$setting['shoutbox_numberoftopshouters']['grouptitle'] = 'shoutbox';
$setting['shoutbox_numberoftopshouters']['value'] = '10';
$setting['shoutbox_numberoftopshouters']['defaultvalue'] = '10';
$setting['shoutbox_numberoftopshouters']['optioncode'] = '';
$setting['shoutbox_numberoftopshouters']['displayorder'] = '5';

$setting['shoutbox_forumhomeshouts']['titlephrase'] = 'Show Latest Shouts on Forum Home?';
$setting['shoutbox_forumhomeshouts']['descphrase'] = 'Setting this to \'yes\' will shout the lateast <i>x</i> shouts on forum home, where <i>x</i> is defined in the next setting.';
$setting['shoutbox_forumhomeshouts']['grouptitle'] = 'shoutbox';
$setting['shoutbox_forumhomeshouts']['value'] = '1';
$setting['shoutbox_forumhomeshouts']['defaultvalue'] = '1';
$setting['shoutbox_forumhomeshouts']['optioncode'] = 'yesno';
$setting['shoutbox_forumhomeshouts']['displayorder'] = '6';

$setting['shoutbox_numberofforumhomeshouts']['titlephrase'] = 'Number of Forum Home Shouts?';
$setting['shoutbox_numberofforumhomeshouts']['descphrase'] = 'Enter the number of shouts to be displayed on forumhome if the option is enabled.';
$setting['shoutbox_numberofforumhomeshouts']['grouptitle'] = 'shoutbox';
$setting['shoutbox_numberofforumhomeshouts']['value'] = '20';
$setting['shoutbox_numberofforumhomeshouts']['defaultvalue'] = '5';
$setting['shoutbox_numberofforumhomeshouts']['optioncode'] = '';
$setting['shoutbox_numberofforumhomeshouts']['displayorder'] = '7';

$setting['shoutbox_enableusernoview']['titlephrase'] = 'Enable User Shout Exclusion?';
$setting['shoutbox_enableusernoview']['descphrase'] = 'Set this to \'yes\' to enable members to view a shouts excluding a specific member\'s..';
$setting['shoutbox_enableusernoview']['grouptitle'] = 'shoutbox';
$setting['shoutbox_enableusernoview']['value'] = '1';
$setting['shoutbox_enableusernoview']['defaultvalue'] = '1';
$setting['shoutbox_enableusernoview']['optioncode'] = 'yesno';
$setting['shoutbox_enableusernoview']['displayorder'] = '8';

$setting['shoutbox_enableuserview']['titlephrase'] = 'Enable User Shout Viewing?';
$setting['shoutbox_enableuserview']['descphrase'] = 'Set this to \'yes\' to enable members to view a specific user\'s shouts.';
$setting['shoutbox_enableuserview']['grouptitle'] = 'shoutbox';
$setting['shoutbox_enableuserview']['value'] = '1';
$setting['shoutbox_enableuserview']['defaultvalue'] = '1';
$setting['shoutbox_enableuserview']['optioncode'] = 'yesno';
$setting['shoutbox_enableuserview']['displayorder'] = '9';

$setting['shoutbox_allowdatecutoff']['titlephrase'] = 'Allow Users to Choose Date Cutoff?';
$setting['shoutbox_allowdatecutoff']['descphrase'] = 'Set this to \'yes\' will allow users to specify an amount of days in which shouts from the last <i>x</i> (the number the user specifies) days are shown.';
$setting['shoutbox_allowdatecutoff']['grouptitle'] = 'shoutbox';
$setting['shoutbox_allowdatecutoff']['value'] = '1';
$setting['shoutbox_allowdatecutoff']['defaultvalue'] = '1';
$setting['shoutbox_allowdatecutoff']['optioncode'] = 'yesno';
$setting['shoutbox_allowdatecutoff']['displayorder'] = '10';

$setting['shoutbox_allowdatebegin']['titlephrase'] = 'Allow Users to Choose Begining Date?';
$setting['shoutbox_allowdatebegin']['descphrase'] = 'Set this to \'yes\' will allow users to specify an amount of days in which shouts posted at least <i>x</i> (the number the user specifies) days ago are shown.';
$setting['shoutbox_allowdatebegin']['grouptitle'] = 'shoutbox';
$setting['shoutbox_allowdatebegin']['value'] = '1';
$setting['shoutbox_allowdatebegin']['defaultvalue'] = '1';
$setting['shoutbox_allowdatebegin']['optioncode'] = 'yesno';
$setting['shoutbox_allowdatebegin']['displayorder'] = '11';

$setting['shoutbox_datecutoffdefault']['titlephrase'] = 'Default Date Cutoff?';
$setting['shoutbox_datecutoffdefault']['descphrase'] = 'Choose the default date cutoff <b>if</b> the option to allow users to chose a date cutoff is enabled.';
$setting['shoutbox_datecutoffdefault']['grouptitle'] = 'shoutbox';
$setting['shoutbox_datecutoffdefault']['value'] = '0';
$setting['shoutbox_datecutoffdefault']['defaultvalue'] = '0';
$setting['shoutbox_datecutoffdefault']['optioncode'] = '';
$setting['shoutbox_datecutoffdefault']['displayorder'] = '12';

$setting['shoutbox_datebegindefault']['titlephrase'] = 'Default Date Begining?';
$setting['shoutbox_datebegindefault']['descphrase'] = 'Choose the default date begining <b>if</b> the option to allow users to chose a date begining is enabled. <b>0 IS STRONGLY RECOMMENDED!</b>';
$setting['shoutbox_datebegindefault']['grouptitle'] = 'shoutbox';
$setting['shoutbox_datebegindefault']['value'] = '0';
$setting['shoutbox_datebegindefault']['defaultvalue'] = '0';
$setting['shoutbox_datebegindefault']['optioncode'] = '';
$setting['shoutbox_datebegindefault']['displayorder'] = '13';

$setting['shoutbox_shoutsperpage']['titlephrase'] = 'Shouts Per Page';
$setting['shoutbox_shoutsperpage']['descphrase'] = 'How many shouts would you like to display per page by default in the shoutbox?';
$setting['shoutbox_shoutsperpage']['grouptitle'] = 'shoutbox';
$setting['shoutbox_shoutsperpage']['value'] = '25';
$setting['shoutbox_shoutsperpage']['defaultvalue'] = '25';
$setting['shoutbox_shoutsperpage']['optioncode'] = '';
$setting['shoutbox_shoutsperpage']['displayorder'] = '14';

$setting['shoutbox_showtopshouters']['titlephrase'] = 'Show Top Shouters?';
$setting['shoutbox_showtopshouters']['descphrase'] = 'Selecting \'yes\' will the users with the top number of shouts.';
$setting['shoutbox_showtopshouters']['grouptitle'] = 'shoutbox';
$setting['shoutbox_showtopshouters']['value'] = '1';
$setting['shoutbox_showtopshouters']['defaultvalue'] = '1';
$setting['shoutbox_showtopshouters']['optioncode'] = 'yesno';
$setting['shoutbox_showtopshouters']['displayorder'] = '4';

$setting['shoutbox_closereason']['titlephrase'] = 'Close Reason';
$setting['shoutbox_closereason']['descphrase'] = 'Enter a reason for closing/disallowing new shouts here.';
$setting['shoutbox_closereason']['grouptitle'] = 'shoutbox';
$setting['shoutbox_closereason']['value'] = 'The shoutbox is closed.';
$setting['shoutbox_closereason']['defaultvalue'] = 'The shoutbox is closed.';
$setting['shoutbox_closereason']['optioncode'] = 'textarea';
$setting['shoutbox_closereason']['displayorder'] = '3';

$setting['shoutbox_allownewshouts']['titlephrase'] = 'Allow New Shouts?';
$setting['shoutbox_allownewshouts']['descphrase'] = 'Setting this to \'no\' will make the shoutbox viewable, but members will not be able to edit, delete, or hard delete their shouts, nor will they be able to post new ones.';
$setting['shoutbox_allownewshouts']['grouptitle'] = 'shoutbox';
$setting['shoutbox_allownewshouts']['value'] = '1';
$setting['shoutbox_allownewshouts']['defaultvalue'] = '1';
$setting['shoutbox_allownewshouts']['optioncode'] = 'yesno';
$setting['shoutbox_allownewshouts']['displayorder'] = '2';

$setting['shoutbox_open']['titlephrase'] = 'Shoutbox Active?';
$setting['shoutbox_open']['descphrase'] = 'If set to \'no\', only admins will be able to view the shoubtox until it is re-opened.';
$setting['shoutbox_open']['grouptitle'] = 'shoutbox';
$setting['shoutbox_open']['value'] = '1';
$setting['shoutbox_open']['defaultvalue'] = '1';
$setting['shoutbox_open']['optioncode'] = 'yesno';
$setting['shoutbox_open']['displayorder'] = '1';

$setting['shoutbox_maxunregshouts']['titlephrase'] = 'Maximum Times a Guest Can Shout?';
$setting['shoutbox_maxunregshouts']['descphrase'] = 'If you allow guests to shout, you can define this option to limit each guest to a certain amount of shouts before they are required to register to shout more. Set this to 0 to have no effect.';
$setting['shoutbox_maxunregshouts']['grouptitle'] = 'shoutbox';
$setting['shoutbox_maxunregshouts']['value'] = '0';
$setting['shoutbox_maxunregshouts']['defaultvalue'] = '0';
$setting['shoutbox_maxunregshouts']['optioncode'] = '';
$setting['shoutbox_maxunregshouts']['displayorder'] = '25';

$setting['shoutbox_shoutminchars']['titlephrase'] = 'Minimum Character Limit?';
$setting['shoutbox_shoutminchars']['descphrase'] = 'Set this to the minimum amount of characters you want to allow per shout. Set this to 0 to have no effect.';
$setting['shoutbox_shoutminchars']['grouptitle'] = 'shoutbox';
$setting['shoutbox_shoutminchars']['value'] = '2';
$setting['shoutbox_shoutminchars']['defaultvalue'] = '5';
$setting['shoutbox_shoutminchars']['optioncode'] = '';
$setting['shoutbox_shoutminchars']['displayorder'] = '26';

$setting['shoutbox_shoutcharlimit']['titlephrase'] = 'Maximum Character Limit?';
$setting['shoutbox_shoutcharlimit']['descphrase'] = 'Set this to the maximum amount of characters you want to allow per shout. Set this to 0 to have no effect.';
$setting['shoutbox_shoutcharlimit']['grouptitle'] = 'shoutbox';
$setting['shoutbox_shoutcharlimit']['value'] = '0';
$setting['shoutbox_shoutcharlimit']['defaultvalue'] = '0';
$setting['shoutbox_shoutcharlimit']['optioncode'] = '';
$setting['shoutbox_shoutcharlimit']['displayorder'] = '27';

$setting['shoutbox_iframe']['titlephrase'] = 'Use an iFrame on Forumhome?';
$setting['shoutbox_iframe']['descphrase'] = 'Setting this to yes will display an iFrame on forumhome instead of the normal &amp;lt;div&amp;gt;. This allows for auto-refreshing and other things but it also increases the total number of queries ran (since the iFrame also includes global.php and the rest of the vB back-end). ';
$setting['shoutbox_iframe']['grouptitle'] = 'shoutbox';
$setting['shoutbox_iframe']['value'] = '1';
$setting['shoutbox_iframe']['defaultvalue'] = '1';
$setting['shoutbox_iframe']['optioncode'] = 'yesno';
$setting['shoutbox_iframe']['displayorder'] = '28';

$setting['shoutbox_iframe_metarefresh']['titlephrase'] = 'Refresh iFrame Every x Seconds?';
$setting['shoutbox_iframe_metarefresh']['descphrase'] = 'Set this to the number of seconds between each automatic refresh of the iFrame on forumhome if you are using the iFrame.';
$setting['shoutbox_iframe_metarefresh']['grouptitle'] = 'shoutbox';
$setting['shoutbox_iframe_metarefresh']['value'] = '90';
$setting['shoutbox_iframe_metarefresh']['defaultvalue'] = '90';
$setting['shoutbox_iframe_metarefresh']['optioncode'] = '';
$setting['shoutbox_iframe_metarefresh']['displayorder'] = '29';

$setting['shoutbox_usestandardtextarea']['titlephrase'] = 'Use Standard Textarea?';
$setting['shoutbox_usestandardtextarea']['descphrase'] = 'Setting this to yes will display a standard textarea instead of the normal toolbar/WYSIWYG editor, since they may be too bulky for the shoutbox.';
$setting['shoutbox_usestandardtextarea']['grouptitle'] = 'shoutbox';
$setting['shoutbox_usestandardtextarea']['value'] = '0';
$setting['shoutbox_usestandardtextarea']['defaultvalue'] = '1';
$setting['shoutbox_usestandardtextarea']['optioncode'] = 'yesno';
$setting['shoutbox_usestandardtextarea']['displayorder'] = '30';


?>




and this:


Database error in vBulletin 3.0.3:

Invalid SQL: ALTER TABLE vb3_language ADD `phrasegroup_shoutbox` MEDIUMTEXT NOT NULL
mysql error: Duplicate column name 'phrasegroup_shoutbox'

mysql error number: 1060

Date: Monday 13th of September 2004 09:08:17 PM
Script: http://www.punktek.com/forums/instal...=Shoutbox_Hack
Referer:
Username: Trunks
IP Address: 166.102.185.155

alzibub 09-14-2004 05:56 PM

Any news on possible fixes, suggestions etc on the iframe issue I have got ?

Thanks and sorry for the hassle...

Link14716 09-15-2004 07:55 PM

Quote:

Originally Posted by babolo
This has way to many errors It should be taken off

No it doesn't. It has a few errors that affect a minority of the users, and people keep reporting, as well as some MySQL errors that look either like I have a bad query, bad version detection, or it's just user error.

Link14716 09-15-2004 07:57 PM

Quote:

Originally Posted by Punktek.com
Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE vb3_user SET uttpoints=uttpoints+.25 WHERE userid='1'
mysql error: Unknown column 'uttpoints' in 'field list'

mysql error number: 1054


Umm....*Confused* My shoutbox doesn't appear on forum home. I can type in forums/shoutbox.php and it'll take me to it. Once I'm there I can type in a shout but it gives me that error up there.

I tried re-installing and got this on the final install page:


[snip]



and this:


Database error in vBulletin 3.0.3:

Invalid SQL: ALTER TABLE vb3_language ADD `phrasegroup_shoutbox` MEDIUMTEXT NOT NULL
mysql error: Duplicate column name 'phrasegroup_shoutbox'

mysql error number: 1060

Date: Monday 13th of September 2004 09:08:17 PM
Script: http://www.punktek.com/forums/instal...=Shoutbox_Hack
Referer:
Username: Trunks
IP Address: 166.102.185.155

Don't post the entire settings.php file, put it in [code] next time, please. It looks like it is just missing the starting tag (<?php) which causes HTML output.

Link14716 09-15-2004 08:00 PM

Quote:

Originally Posted by alzibub
Any news on possible fixes, suggestions etc on the iframe issue I have got ?

Thanks and sorry for the hassle...

Quote your original post or provide a link to it, or repost it. It's hard searching through all these posts to find one post on one particular issue.

Link14716 09-15-2004 08:01 PM

Quote:

Originally Posted by RasMasta
It doesn't let me upgrade

The installer should autodetect whether or not you have 1.03 installed and will uograde instead of doing a fresh install, thus making that query not be ran, and not causing an error.

Link14716 09-15-2004 08:04 PM

Quote:

Originally Posted by Link14716
Alright.
Second, to everyone getting those errors starting with "Warning: readdir(): supplied argument is not a valid Directory resource in /htdocs/www/forum/install/hack_install.php on line 22". I need more information. Web server (probably apache) and version and PHP version. Otherwise it'll be hard for me to fix this since I cannot reproduce this error, and the functions used dates back to PHP3.

I'm still waiting for this information from people who have this error so I can investigate - which is kind of hard to do without knowing what causes the error or being able to reproduce it myself.

TruthElixirX 09-15-2004 08:23 PM

Quote:

Originally Posted by Link14716
Don't post the entire settings.php file, put it in [code] next time, please. It looks like it is just missing the starting tag (<?php) which causes HTML output.

Thanks and sorry.

Valr the Slain 09-15-2004 09:37 PM

Quote:

Originally Posted by Link14716
I'm still waiting for this information from people who have this error so I can investigate - which is kind of hard to do without knowing what causes the error or being able to reproduce it myself.

Apache 1.3.29, PHP 4.3.4, here.

alzibub 09-15-2004 09:41 PM

Quote:

Originally Posted by Link14716
Quote your original post or provide a link to it, or repost it. It's hard searching through all these posts to find one post on one particular issue.

Sorry bout that !!

https://vborg.vbsupport.ru/showpost....&postcount=122

Basically I narrowed it down to the iframe...
You cant see any shouts - if you shout nothing appears...
If you check shoutbox.php - they are there...
Also - if you use the static/manual mode - then you can see shouts and post shouts...

I posted this over on GeekyDesigns.com - including a link to a fix you gave me when you posted 1.02 and I had the same issue ..

https://vborg.vbsupport.ru/showpost....&postcount=257

Thanks in advance - sorry for any additional burden - it is a great hack :)

BTW - I said I was having phrase issues that suddenly corrected - well on a different hack there was the same deal - if you open/edit any phrase - dont make any changes and save it - seems to fix missing phrases :)

Diva 09-17-2004 01:13 AM

Hi guys. I notice that when the member has standard editor selected the smilie box does not work. Right now I'm telling people to use the Enhanced one... but they would prefer not to.

TexasAtvs 09-17-2004 03:10 AM

I have my shoutbox at the bottom of the forums and when a member hits "shout now" it takes them to the top of the forums page after they submit there shout.

How do I get it to send the member back to the shoutbox towards the bottom after they submit there "shout"?? Thanks for your help!

Brandon

akirauk 09-17-2004 12:51 PM

I get these errors when i try and install -

PHP Code:

Warninghalt(./includes/functions_log_error.php): failed to open streamNo such file or directory in /homepages/37/d107552158/htdocs/wsc107552164/forum/includes/db_mysql.php on line 389

Warning
halt(): Failed opening './includes/functions_log_error.php' for inclusion (include_path='.:/usr/local/lib/php'in /homepages/37/d107552158/htdocs/wsc107552164/forum/includes/db_mysql.php on line 389

 

There seems to have been a slight problem with the Project
-A Forums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staffwho you can also contact if the problem persists.

We apologise for any inconvenience


and this is the sql error -

Database error in vBulletin 3.0.3:

PHP Code:

Invalid SQLALTER TABLE language ADD `phrasegroup_shoutboxMEDIUMTEXT NOT NULL
mysql error
Duplicate column name 'phrasegroup_shoutbox'

mysql error number1060

Date
Friday 17th of September 2004 03:44:52 PM 


heres my php version - PHP Version 4.3.8

ive sort of got it working bby carrying on with the rest of the install , and also ive tried to delete the tables as shown on page 5 but when i goto edit settings in group manager i get sql errors, when i got post a shout i get mysql errors too.

hope someone can help, might end up uninstalling this otherwise.

regards

alzibub 09-17-2004 09:50 PM

Quote:

Originally Posted by alzibub
Sorry bout that !!

https://vborg.vbsupport.ru/showpost....&postcount=122

Basically I narrowed it down to the iframe...
You cant see any shouts - if you shout nothing appears...
If you check shoutbox.php - they are there...
Also - if you use the static/manual mode - then you can see shouts and post shouts...

I posted this over on GeekyDesigns.com - including a link to a fix you gave me when you posted 1.02 and I had the same issue ..

https://vborg.vbsupport.ru/showpost....&postcount=257

Thanks in advance - sorry for any additional burden - it is a great hack :)

BTW - I said I was having phrase issues that suddenly corrected - well on a different hack there was the same deal - if you open/edit any phrase - dont make any changes and save it - seems to fix missing phrases :)

OK - cross this one off the list....

Little embaressed here - but after a bit of fault finding with another member of staff - seems the iframe not working was just me...
Very quickly I realised my Nortons firewall was killing the iframe as it though it was a popup window...

Really sorry about that - and thanks for a wicked hack !!!

Vman 09-18-2004 03:13 PM

How would one go about changing the size of the Shout Box, on my site it appears to be to wide and its causing the site to go off screen....

Which template whould I have to modify for this?

Thanks

"and I clicked installed" works great!!!!!

Link14716 09-19-2004 12:21 AM

Quote:

Originally Posted by akirauk
I get these errors when i try and install -

PHP Code:

Warninghalt(./includes/functions_log_error.php): failed to open streamNo such file or directory in /homepages/37/d107552158/htdocs/wsc107552164/forum/includes/db_mysql.php on line 389

Warning
halt(): Failed opening './includes/functions_log_error.php' for inclusion (include_path='.:/usr/local/lib/php'in /homepages/37/d107552158/htdocs/wsc107552164/forum/includes/db_mysql.php on line 389

 

There seems to have been a slight problem with the Project
-A Forums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staffwho you can also contact if the problem persists.

We apologise for any inconvenience


and this is the sql error -

Database error in vBulletin 3.0.3:

PHP Code:

Invalid SQLALTER TABLE language ADD `phrasegroup_shoutboxMEDIUMTEXT NOT NULL
mysql error
Duplicate column name 'phrasegroup_shoutbox'

mysql error number1060

Date
Friday 17th of September 2004 03:44:52 PM 


heres my php version - PHP Version 4.3.8

ive sort of got it working bby carrying on with the rest of the install , and also ive tried to delete the tables as shown on page 5 but when i goto edit settings in group manager i get sql errors, when i got post a shout i get mysql errors too.

hope someone can help, might end up uninstalling this otherwise.

regards

The queries you ran WERE for uninstallation. Run the installer again. (might need another query though if you completed the installer.) ^_^

Was the installation an upgrade or a fresh install?

Link14716 09-19-2004 12:24 AM

Quote:

Originally Posted by Valr the Slain
Apache 1.3.29, PHP 4.3.4, here.

Well then I have absolutely no idea...

akirauk 09-19-2004 09:50 AM

Quote:

Originally Posted by Link14716
The queries you ran WERE for uninstallation. Run the installer again. (might need another query though if you completed the installer.) ^_^

Was the installation an upgrade or a fresh install?


it was for a fresh installation :)

Vman 09-20-2004 11:49 PM

Quote:

Originally Posted by BBCVman
How would one go about changing the size of the Shout Box, on my site it appears to be to wide and its causing the site to go off screen....

Which template whould I have to modify for this?

Thanks

"and I clicked installed" works great!!!!!




BUMP!

moley 09-21-2004 02:58 PM

EDIT

nevermind i had some sleep and noticed i forgot to upload the back up files:p

Harley D 09-26-2004 05:29 AM

In my ADMINCP, I do not see and SHOUTBOX drop down menu on the left side, I have found in ADMIN PERMISSIONS that there is a blank with a yes/no check box.

I have installed and uninstalled BVShoutbox FULL about 50 times in the past 2 weeks and failed to get it to work. I HAVE however managed to get yours to work, its just the ADMINPC permissions are missing. Thanks for such an easy to install hack and for actually giving support, unlike the last hack i mentioned.

I am running VB 3.0.1 is this the cause? or should I uninstall and reinstall the tables?

Thanks again.

Roms 09-26-2004 10:12 AM

Well I had some free time so I tried it again... Got it to work. Thanks.



*clicks install ;)

THE REAL BLAZE 09-26-2004 06:09 PM

PHP Code:

Database error in vBulletin 3.0.3:

Invalid SQLALTER TABLE language ADD `phrasegroup_shoutboxMEDIUMTEXT NOT NULL
mysql error
Duplicate column name 'phrasegroup_shoutbox'

mysql error number1060

Date
Sunday 26th of September 2004 12:08:16 PM
Script
: [url]http://www.urban101.net/forums/install/hack_install.php?do=install&step=dodatabasequeries&hacks=Shoutbox_Hack[/url]
Referer
Username: ****** 
IP Address: ******* 

thats what i get after the "Rebuild Style" set
, any suggestions?

Roms 09-26-2004 09:46 PM

I take that back.... This hack has some problems. You change styles on the page it errors, most times the shouts don't showup. I'm just glad I finally got the entire thing removed.

I'm not touching this again with a 10 foot pole.....

*Clicks UNINSTALL

Zachery 09-26-2004 09:51 PM

Quote:

Originally Posted by THE REAL BLAZE
PHP Code:

Database error in vBulletin 3.0.3:

Invalid SQLALTER TABLE language ADD `phrasegroup_shoutboxMEDIUMTEXT NOT NULL
mysql error
Duplicate column name 'phrasegroup_shoutbox'

mysql error number1060

Date
Sunday 26th of September 2004 12:08:16 PM
Script
: [url]http://www.urban101.net/forums/install/hack_install.php?do=install&step=dodatabasequeries&hacks=Shoutbox_Hack[/url]
Referer
Username: ****** 
IP Address: ******* 

thats what i get after the "Rebuild Style" set
, any suggestions?

Did you have another shotbox hack installed?

Zachery 09-26-2004 09:52 PM

Quote:

Originally Posted by infantrymen
I take that back.... This hack has some problems. You change styles on the page it errors, most times the shouts don't showup. I'm just glad I finally got the entire thing removed.

I'm not touching this again with a 10 foot pole.....

*Clicks UNINSTALL

Errors how? JS or somthing else?

We've not had any major errors on the developemnt site or we would not have released it

Harley D 09-26-2004 11:32 PM

Quote:

Originally Posted by Harley D
In my ADMINCP, I do not see and SHOUTBOX drop down menu on the left side, I have found in ADMIN PERMISSIONS that there is a blank with a yes/no check box.
I am running VB 3.0.1 is this the cause? or should I uninstall and reinstall the tables?

Thanks again.

Any suggestions/ideas?

sunruh 09-26-2004 11:42 PM

Quote:

Originally Posted by snake-boy
Hi,

I just installed and all was going very well. No errors etc.

Once done, I tried to test it out, but it's simply not there!? The ONLY mention of it that I can find is in the Options dropdown. The "Shoutbox Options" are not visible in my user editor or in the usergroup settings.

What did I miss and how to fix?

(Running vb 3.0.3 and once again I should mention that I there were no errors or complaints of any kind during the setup. The shoutbox is enabled as well as the board.

Please, can anyone make a recommendation on how to proceed.

Regards

--snake

-EDIT/UPDATE: I have now just attempted a reinstall. Same problem. No complaints during installation. In the Admincp Users and Usergroups options make NO mention of the shoutbox.

The "Vbulletin Options" dropdown menu lists "shoutbox options" however changing any settings here failed to get the shoutbox to actully SHOW UP on the forumhome.

I can point my browser DIRECTLY at the shoutbox.php file on the webserver, and on that page everything works "as advertised".
I just cannot get it to show up on the forumdisplay. Double checked settings.
Cannot access any shoutbox options in user accounts usergroups, they appear as they've always been.

Could anyone PLEASE help!..

regards

-snake

i just installed it and i get the EXACT SAME THING!!!
i can point directly at shoutbox.php and get it, but NOT any other way.
i read all 10 pages of posts and don't see an answer either.

plus, is there any way to arrange the shout boxes?

Roms 09-27-2004 01:31 AM

Quote:

We've not had any major errors on the developemnt site or we would not have released it
Yeah, that's why there are 10 pages worth of people not being able to install and or use the hack. :b

Zachery 09-27-2004 03:37 AM

Quote:

Originally Posted by infantrymen
Yeah, that's why there are 10 pages worth of people not being able to install and or use the hack. :b

We installed it on our developemnt forums, on fresh forums (with no errors) and on matthews live forum with no issues.

What errors were you having?

Megareus Rex 09-27-2004 04:24 AM

An error I'm having (and I've told Matthew about it too), is that when I try to run the install/hack_install.php script, all I get is a blank white screen. I've triple-checked everything, and it happens every time.

Zachery 09-27-2004 05:10 AM

Quote:

Originally Posted by Megareus Rex
An error I'm having (and I've told Matthew about it too), is that when I try to run the install/hack_install.php script, all I get is a blank white screen. I've triple-checked everything, and it happens every time.

Do you get a white page onj any other scripts? Have you tried reuploading the files again (some ftp programs can be rather naughty at times ;))

btw nice avatar :)

Zachery 09-27-2004 05:12 AM

Quote:

Originally Posted by infantrymen
Yeah, that's why there are 10 pages worth of people not being able to install and or use the hack. :b

We have 127 pages on uCS release thread, im sure there are TONS of people who had issues installing, mostly due to user error :) a very small percentage of which are actually the installers issue.

the installer works fine on linux and windows on php 4.3.8 we don't know why people are getting specific errors but we are working on fixing them.

Harley D 09-27-2004 12:24 PM

Quote:

Originally Posted by Harley D
In my ADMINCP, I do not see and SHOUTBOX drop down menu on the left side, I have found in ADMIN PERMISSIONS that there is a blank with a yes/no check box.

I have installed and uninstalled BVShoutbox FULL about 50 times in the past 2 weeks and failed to get it to work. I HAVE however managed to get yours to work, its just the ADMINPC permissions are missing. Thanks for such an easy to install hack and for actually giving support, unlike the last hack i mentioned.

I am running VB 3.0.1 is this the cause? or should I uninstall and reinstall the tables?

Thanks again.

O.K. Let me ask this...
where is the call made to settings.php?

hawkin 09-28-2004 09:48 AM

Upgrade from TWTCommish Shoutbox hack.

I have sucessfully installed and got the shouts transferred to the new Hack, but the last step (?do=update) takes forever and URL Redirect timeout after a long period. I guess the reason is cause we have alot of shouts, and that the update procedure just takes too long time.
Is there any possible to work this out?
I'm not sure what the update procedure does.
Only thing I have figured out is it updates the username fields from the userid in the table.

Harley D 09-28-2004 03:33 PM

Quote:

Originally Posted by Link14716
The uninstall queries: in SQL format for version 1.04. Run these queries in phpMyAdmin:

[sql]ALTER TABLE language DROP phrasegroup_shoutbox;

DELETE FROM phrasetype WHERE phrasetypeid=716;

DROP TABLE IF EXISTS shoutbox_posts;

ALTER TABLE usergroup
DROP `shoutboxpermissions`,
DROP `shouthierarchy`,
DROP `shoutmaxdaily`;

ALTER TABLE user
DROP `shouts`,
DROP `shoutbanned`;
[/sql]

Now re-install.

Tried to uninstall so I could reinstall in attempt to get permissions to show up in adminpc.
did not uninstall properly, errored out, so I ran the above queries in phpMyAdmin. Undid all the file changes and then tried to reinstall.
But the installer is still showing that I have shoutbox 1.04 currently installed and will not reinstall?
Please help

Thanks in advance

Magicmule 09-28-2004 10:50 PM

How can i Delete Shouts ? Is there an Option to do this `?

Sorry for my English :nervous:

Harley D 09-29-2004 02:59 AM

All I want to do is UNINSTALL all the TABLES form MYSQL!
So I can reinstall the hack.
There has to be something left somewhere in the tables, I removed all file edits and also I've tried to delete the tables as shown on page 5 and still the install program see's that I have it installed and won't let me reinstall.

any suggestions.

EDIT] I found in the install php file, that it looks to the table "his_installed" If I'm correct, it this the little sucker thats keeping me from reinstalling? and is thid safe to delete?

Apache 1.3.31

PHP Version 4.3.6

vBulletin 3.0.1


All times are GMT. The time now is 12:58 PM.

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.07388 seconds
  • Memory Usage 2,001KB
  • 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
  • (6)bbcode_php_printable
  • (24)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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