vb.org Archive

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)

Black Vivi 04-13-2003 05:23 PM

[high]* Black Vivi clicks install, but not gonna install it later.
[/high]
I'll prob redesign it alot aswell, but looks k00l;):D

Craigr 04-13-2003 05:25 PM

Thanks, looks great.

Craig

filburt1 04-13-2003 05:29 PM

Quote:

Today at 02:12 PM Xelation said this in Post #10
when I ran install_usercomment.php I got this error when it tried to run the 3rd query.. what could be wrong?

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:11:37 PM
Script: http://www.texeo.com/web/web/admin/i...es=1&styleid=1
Referer: http://www.texeo.com/web/admin/install_usercomment.php

Anybody else getting this?

Either way I updated the script with a query straight from PMA. Run this query:
[sql]
DROP TABLE usercomment;
[/sql]
Then re-run the install script.

Zelda-King 04-13-2003 05:30 PM

This doesn't like me. I'm stumped on step one of running the installation script. :/
Quote:

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 near '"usergroup" ADD "candeleteusercomments"
SMALLINT(6) DEFAULT 0 NOT NULL' at line 1

mysql error number: 1064

Date: Sunday 13th of April 2003 12:22:56 PM
Script: http://www.gamercrossfire.net/bb/bb/...es=1&styleid=4
Referer: http://www.gamercrossfire.net/bb/adm...sercomment.php

filburt1 04-13-2003 05:30 PM

See my post above.

Xelation 04-13-2003 05:31 PM

I ran that query and now I get this error
----------------------------------------------------------
Database texeoco_web running on localhost
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 22
STR: '
SQL: DROP TABLE usercomment'
Error

SQL-query :

DROP TABLE usercomment'

MySQL said:

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 ''' at line 1
Back

filburt1 04-13-2003 05:31 PM

I edited my post one second after you copied that query :p, look again.

Xelation 04-13-2003 05:33 PM

ok, I dropped it and reinstalled it.. same error

bharvey42 04-13-2003 05:34 PM

Hey filburt,

Would it be possible to allow groups the ability to only comment on users in the same group?

Would it be possible to enable the user of having there comments be viewed by only themselves and admins?

Zelda-King 04-13-2003 05:35 PM

Gah! I HAD seen that post. I just didn't recognise it was the same error (and I downloaded just after seeing that. I assumed I had the updated version)! :-[


All times are GMT. The time now is 08:44 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
  • Page Generation 0.01263 seconds
  • Memory Usage 1,740KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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