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)
-   -   vbHome (lite) - your vBulletin(powered) main homepage (https://vborg.vbsupport.ru/showthread.php?t=36756)

The Piper 10-02-2002 03:56 AM

I had vbIndex and had not reverted/deleted the templates (home_yaddayaddayadda), so things weren't working quite well. I tried to uninstall vbHome, but got an error. Tried again, and got another error, although this time it could at least remove the templates.

Then, I reinstalled it. It created the set of templates successfully ("Tables modifications and templates installed successfully."). Then, in the next screen I got this error:

Quote:

Adding new options group... Done.
There seems to have been a slight problem with the All Pink Floyd Fan Network database.

(yadda yadda yadda)~
Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: INSERT INTO settinggroup VALUES (99,'vbHome Page','99')
mysql error: Duplicate entry '99' for key 1

mysql error number: 1062

Date: Wednesday 02nd of October 2002 12:54:52 AM
Script: http://www.pinkfloydfan.net/admin/vbhinstall.php?step=4
Referer: http://www.pinkfloydfan.net/admin/vbhinstall.php?step=3
.

And then the page is half missing. I mean, I get the welcome panel, the polls, latest forum discussions and friends and affiliates, but nothing in the main part of the page or anything.

Any help would be greatly appreciated!

Thanks a lot,
Paulo

PS: I look forward to having this online on my site. :)

hypedave 10-02-2002 03:56 AM

Quote:

Originally posted by TECK
hypedave, try it. :) i didnt used the classic zip archiving that any kid could open it in 30min :)
but i will send you the password. ofcourse.. especially that i know you.. i still have you on the msn list, remember? :)


Hell for a moment I was beginning to wonder what ego horse you jumped on :confused: oh yeah I still got you on msn to, remember ;)

TECK 10-02-2002 03:57 AM

is because you tried to install it twice. run the uninstaller.

bouncer18 10-02-2002 03:58 AM

Quote:

Originally posted by nokia8860
fresh install. posted polled and everythign yet all i get is this?

maybe i am destined to go without a poll :banana:


hmmm seems he has duplicated the error...

if its working on localhost tho i dont see how it couldnt be working here...

anyhow here is my screen shot too..

mine has arrows and yours doesnt so HA!

The Piper 10-02-2002 03:59 AM

Whenever I run the uninstaller, on the first screen, I get this:
Quote:

Removing from thread table the articleid field... Done.
Removing the thread table the articleid index... Done.
And then the following error message:
Quote:

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: ALTER TABLE thread DROP INDEX articleid
mysql error: Can't DROP 'articleid'. Check that column/key exists

mysql error number: 1091

Date: Wednesday 02nd of October 2002 12:58:25 AM
Script: http://www.pinkfloydfan.net/admin/vb...ll.php?step=11
Referer: http://www.pinkfloydfan.net/admin/vb...ll.php?step=10
Then, if I hit 'back' on my browser and then "continue" again, I get the following screen:
Quote:

Droping the fields and removing script elements
Removing home template... Done.
Removing home_articlebits template... Done.
Removing home_headinclude template... Done.
Removing home_header template... Done.
Removing home_footer template... Done.
Removing home_threadbits template... Done.
Removing home_welcomeguest template... Done.
Removing home_welcomeuser template... Done.
Removing home_articlecomment template... Done.
Removing home_articlenocomment template... Done.
Removing home_pollresult template... Done.
Removing home_polloption_multiple template... Done.
Removing home_polloption template... Done.
Removing home_pollcomment template... Done.
Removing home_pollresults template... Done.
Removing home_pollresults_closed template... Done.
Removing home_pollresults_voted template... Done.
Removing home_polloptions template... Done.
Removing home_pmloggedin template... Done.
Removing home_userloggedin template... Done.
Removing home_userloggedout template... Done.
Removing home_linkbit template... Done.
Removing home_advertisementbit template... Done.
Removing home_printarticle template... Done.
Removing home_printarticlebit template... Done.

ERROR: The script reported errors during the uninstall.

Error number: 1054
Error description: Unknown column 'articleid' in 'field list'


Uninstall completed!
The file the you need to delete: vbhinstall.php
Please Help! :)

TECK 10-02-2002 04:00 AM

ok, let's try this code, for the poll (replace the old query with this one):
Code:

SELECT thread.* FROM thread LEFT JOIN poll ON (poll.pollid=thread.pollid) WHERE thread.visible=1 AND thread.open<>10 $iforumperms $ipollperms ORDER BY thread.pollid DESC LIMIT 1

TECK 10-02-2002 04:02 AM

the piper, you are ok. is uninstalled. :)
now first read the readme file carefully. do not run the installer just like that, ok? get back to me on this.

nokia8860 10-02-2002 04:02 AM

Quote:

Originally posted by TECK
ok, let's try this code:
Code:

SELECT thread.* FROM thread LEFT JOIN poll ON (poll.pollid=thread.pollid) WHERE thread.visible=1 AND thread.open<>10 $iforumperms $ipollperms ORDER BY thread.pollid DESC LIMIT 1

should i do this too?

TECK 10-02-2002 04:03 AM

hold on let me post excaly the change nokia, ya do it to.

in vbhome index.php, find:
Code:

SELECT * FROM thread LEFT JOIN poll ON (poll.pollid=thread.pollid) WHERE thread.visible=1 AND thread.open<>10 $iforumperms $ipollperms ORDER BY thread.pollid DESC LIMIT 1
replace it with:
Code:

SELECT thread.* FROM thread LEFT JOIN poll ON (poll.pollid=thread.pollid) WHERE thread.visible=1 AND thread.open<>10 $iforumperms $ipollperms ORDER BY thread.pollid DESC LIMIT 1

TECK 10-02-2002 04:08 AM

no, bouncer. please delete the installer code. thank you.
just read the post i made before, on how to change the code.


All times are GMT. The time now is 03:48 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.03398 seconds
  • Memory Usage 1,755KB
  • 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_code_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)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