vb.org Archive
Page 3 of 12 12 3 45 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   User Comment System (https://vborg.vbsupport.ru/showthread.php?t=51570)

Craigr 04-13-2003 05:40 PM
Quote:
Today at 07:27 PM Xelation said this in Post #18
ok, I dropped it and reinstalled it.. same error
Same here. I get this error:

Quote:
Code:
Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: ALTER TABLE "usergroup" ADD "candeleteusercomments"
        SMALLINT(6) DEFAULT 0 NOT NULL
mysql error: 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 '"usergroup" ADD "candeleteusercomments"
        SMALLINT(6) DEF

mysql error number: 1064

Date: Sunday 13th of April 2003 02:32:24 PM
Script: http://www.steven-seagal.net/forum/f...es=1&styleid=1
Referer: http://www.steven-seagal.net/forum/a...sercomment.php
Craig

filburt1 04-13-2003 05:54 PM
Try again.

Xelation 04-13-2003 05:59 PM
Quote:
Running extra queries...
Running extra query 1 of 3...

query: CREATE TABLE usercomment (
usercommentid int(10) unsigned NOT NULL auto_increment,
byuserid int(10) unsigned NOT NULL default '0',
aboutuserid int(10) unsigned NOT NULL default '0',
comment text NOT NULL,
PRIMARY KEY (usercommentid)
) TYPE=MyISAM
Running extra query 2 of 3...

query: ALTER TABLE "usergroup" ADD "candeleteusercomments"
SMALLINT(6) DEFAULT 0 NOT NULL


There seems to have been a slight problem with the Death Raiders database.
Please try again by pressing the refresh button in your browser.

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

We apologise for any inconvenience.

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: ALTER TABLE "usergroup" ADD "candeleteusercomments"
SMALLINT(6) DEFAULT 0 NOT NULL
mysql error: 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 '"usergroup" ADD "candeleteusercomments"
SMALLINT(6) DEF

mysql error number: 1064

Date: Sunday 13th of April 2003 02:53:03 PM
Script: http://www.texeo.com/web/web/admin/i...es=1&styleid=1
Referer: http://www.texeo.com/web/admin/install_usercomment.php

Craigr 04-13-2003 06:00 PM
Works great now.

Thanks
Craig

Xelation 04-13-2003 06:00 PM
craigr.. what did you do?

Zelda-King 04-13-2003 06:02 PM
It works better now. Just clear out your cache and redownload, etc.

Xelation 04-13-2003 06:05 PM
thx zelda... worked :)

Zelda-King 04-13-2003 06:16 PM
I've installed. Works great so far! :)

Craigr 04-13-2003 06:16 PM
To leave comments about yourself remove this from commentaboutuser.php

Code:
if ($aboutuserid == $bbuserinfo['userid'])
{
    eval("standarderror(\"" . gettemplate("error_cantcommentaboutself") .
        "\");");
}
You can also remove the template.

Works for me.

Craig

Xelation 04-13-2003 06:18 PM
Not saying you have to create all these features but they would be nice to have....[list=1][*]Let yourself comment on yourself (incase people may want to ask questions and such then you can reply).[*]Time posted[*]give me a code to put their avatar somewhere in comment.[*]Other buttons like on the postbit (email, profile, etc).[*]Show most recent comment on the profile page (such as a simple value like $recentcomment). Have an extra template for this so we can customize the look of it[*]Have a reply button on the actual comment page[/list=1]


All times are GMT. The time now is 09:12 AM.
Page 3 of 12 12 3 45 Last »
Show 40 post(s) from this thread on one page

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.01120 seconds
  • Memory Usage 1,739KB
  • 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
  • (2)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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