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)
-   -   Avatar Hack: Categories & Usergroups (https://vborg.vbsupport.ru/showthread.php?t=24997)

bad_madman 09-19-2001 08:57 AM

[QUOTE]Originally posted by SirSteve

It goes to Test Ouput 2 then when I hit continue, page not found.

It also says this:
Tables, fields and records in SQL-Database exists already...

but in myphpadmin it doesn't show any new tables. ??

SirSteve 09-19-2001 02:46 PM

Quote:

Originally posted by Bad_Madman
Yes, that is correct. I let the table "settings" check only whether the avatar options are already entered there. That seems to be with you the case.

Ok. Delete please manually with phpMyAdmin the 3 entries in the table 'settings':
-varname='avataroptions' and
-varname='avatarpermissions' and
-varname='avatarselect1'
Start afterwards the file sqltodos.php again.

I don't have a table "settings" (plural) but I do have a "setting" table but there are no avatar fields in there. ??

bad_madman 09-19-2001 03:27 PM

Also no entry 'avataroptions' (in table 'setting' - not 'settings' - sorry)? This is checked in the script 'sqltodos.php'. If it exists then the script outputs that all tables would be already created ('Tables, fields and records in SQL-Database exists already...').

If this entry in the table 'setting' is available (and that would have it), then please also times to delete.

SirSteve 09-19-2001 03:43 PM

Quote:

Originally posted by Bad_Madman
Also no entry 'avataroptions' (in table 'setting' - not 'settings' - sorry)? This is checked in the script 'sqltodos.php'. If it exists then the script outputs that all tables would be already created ('Tables, fields and records in SQL-Database exists already...').

If this entry in the table 'setting' is available (and that would have it), then please also times to delete.

Not sure what you are saying or asking but in the database "setting" there are these fields:

Database vforums - table setting
settingid
settinggroupid
title
varname
value
description
optioncode
displayorder

That is all.

bad_madman 09-19-2001 10:58 PM

If I incomprehensibly write then excuse please.
I mean: does in the table 'setting' an entry with the varname 'avataroptions' exist?

If this entry exists, delete then please.

Normally this entry must exist in your SQL-DB, since the Script outputs the message 'Tables, fields and records in SQL-Database exists already...'. Because the script 'sqltodos.php' seeks to check in the SQLDB only after this entry over whether the necessary modifications (for the avatar-hack) were already executed to the SQLDB.

SirSteve 09-20-2001 12:26 AM

Quote:

Originally posted by Bad_Madman
[B]If I incomprehensibly write then excuse please.
I mean: does in the table 'setting' an entry with the varname 'avataroptions' exist?

If this entry exists, delete then please.
The entry does not exist.

bad_madman 09-20-2001 11:44 PM

There I am rather helpless. If you get the message 'Tables, fields and records in SQL-Database exists already...', then also the varname 'avataroptions' would have to exist.

Did you already try the fixed Script http://www.vbulletin.com/forum/showt...776#post166776 (with test output)? With this also the error should be fixed ('page not found'). Otherwise I have no more advice.

SirSteve 09-21-2001 06:01 PM

Quote:

Originally posted by Bad_Madman
There I am rather helpless. If you get the message 'Tables, fields and records in SQL-Database exists already...', then also the varname 'avataroptions' would have to exist.

Did you already try the fixed Script http://www.vbulletin.com/forum/showt...776#post166776 (with test output)? With this also the error should be fixed ('page not found'). Otherwise I have no more advice.

Says this. Tables, fields and records in SQL-Database exists already...

So I click Remove and get this:

Database error in vBulletin Control Panel: Invalid SQL: DROP TABLE avatar_categories
mysql error: Unknown table 'avatar_categories'
mysql error number: 1051
Date: Friday 21st of September 2001 02:58:00 PM
Script: /forums/admin/sqltodos.php
Referer: http://www.sirstevesguide.com/forums.../sqltodos.php?

MrLister 09-21-2001 10:26 PM

why does it show nothing on my avatar screen. i followed the instructions and clicked on change avatar and nothing was there.

magistr 09-22-2001 09:26 AM

yhanx man it coll
it work 2.0.3


All times are GMT. The time now is 02:53 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.01487 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (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