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)
-   -   vBindex v2.1 (https://vborg.vbsupport.ru/showthread.php?t=41916)

Limpkinw 10-19-2002 06:21 AM

Only one issue with this. The smilies in shoutbox do not seem to work. Any idea on this?

NTLDR 10-19-2002 06:09 PM

Quote:

Originally posted by Jalrock
Everything works fine but when I try to add a usergroup I get this error. Any ideas?

Database error in vBulletin Control Panel 2.2.8:

You haven't edited usergroup.php correctly.

NTLDR 10-19-2002 06:13 PM

Quote:

Originally posted by Limpkinw
Only one issue with this. The smilies in shoutbox do not seem to work. Any idea on this?
You need to make sure the similes have the full URL in the ACP.

Chris M 10-19-2002 06:28 PM

What are the changes from RC1 to RC2?

If you could post what PHP changes there were, that would be great!:)

Satan

NTLDR 10-19-2002 06:43 PM

There are 12 changes in vbindex.php, 3 insertions, 1 removal and the rest are edits.

The main change for RC2 was the installer and all the templates re-coded properly.

If you want to send me your vbindex.php if you have made PHP edits then I can merge them for you and upgrade it to RC2 ;)

Chris M 10-19-2002 06:50 PM

Ah cool:)

PM it to you?

Satan

NTLDR 10-19-2002 07:14 PM

Sure PM it to me now and I'll do it while I have some free time :)

Chris M 10-19-2002 07:18 PM

Cool thanks:)

Satan

NTLDR 10-19-2002 07:30 PM

PM'ed you the upgraded file :D

Chris M 10-19-2002 07:35 PM

Thanks:)

It appears to work without faults:)

Satan

NTLDR 10-19-2002 07:45 PM

No problem Satan, glad its working fine :)

Chris M 10-19-2002 07:46 PM

Yup...

I noticed that there was no "Online Users Today" info in it, so I added that back...

:)

Is that meant to be in RC2?

Satan

NTLDR 10-19-2002 07:52 PM

Quote:

Originally posted by hellsatan
I noticed that there was no "Online Users Today" info in it, so I added that back...
Is that meant to be in RC2?

Some users were still reporting that the Number of Online Users Today and the Record amounts were being reset. I therefore saved some queries and removed the code for that so to be sure it isn't this hack causing problems.

Chris M 10-19-2002 07:56 PM

I see...

Well I added it back to mine:)

I presume the templates have that bit removed;)

I personally prefer it:)

Satan

NTLDR 10-19-2002 08:03 PM

I liked the feature too, but it was removed to help prevent bugs, I will try and find a way to get this going more efficiently for v2.1 Final.

And yes the v2.1 templates in the installer have it removed :D

Chris M 10-19-2002 08:08 PM

Cool...

Well I'll keep the old code till you find a way:)

Satan

groovesalad 10-19-2002 11:55 PM

NTLDR- Once I installed this, I get this error when trying to add a new User Group

Quote:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: INSERT INTO usergroup (usergroupid,title,usertitle,cancontrolpanel,canmo difyprofile,canviewmembers,canview,canviewvbindex, showgroup,cansearch,canemail,canpostnew,canmove,ca nopenclose,candeletethread,canreplyown,canreplyoth ers,canviewothers,caneditpost,candeletepost,canuse pm,canpostpoll,canvote,canpostattachment,ismoderat or,canpublicevent,canpublicedit,canthreadrate,cant rackpm,candenypmreceipts,maxbuddypm,maxforwardpm,c anwhosonline,canwhosonlineip,cangetattachment)
VALUES (NULL,'test','',0,1,1,,,1,1,0,0,0,0,0,0,0,1,0,0,1, 1,1,1,0,0,0,1,0,0,0,0,1,0,1)
mysql error: You have an error in your SQL syntax near ',1,1,0,0,0,0,0,0,0,1,0,0,1,1,1,1,0,0,0,1,0,0,0,0, 1,0,1)' at line 2

mysql error number: 1064

Date: Saturday 19th of October 2002 05:52:56 PM
Script: http://groove-salad.com/forum/forum/admin/usergroup.php
Referer: http://www.groove-salad.com/forum/ad...?action=add&s=
any ideas?

groovesalad 10-20-2002 04:29 PM

top

NTLDR 10-20-2002 04:48 PM

The answer has allready been posted, please read the thread first. You haven't edited usergroup.php correctly.

Theres never any need to bump a thread less that 24hrs minimum after it has been posted.

groovesalad 10-20-2002 05:02 PM

Read 52 pages of thread? Ok. I followed the hack.txt to a T and still the error exists.

groovesalad 10-20-2002 05:32 PM

I followed what you said on this post
https://vborg.vbsupport.ru/showthrea...700#post285700

And still I have the same issue. I even replaced my usergroup.php file with the original one and re did the hack. Still the same problem. It's calling www.groove-salad.com/forum/forum when it should only have one forum in the URL. Any ideas?

groovesalad 10-23-2002 10:35 PM

Once I upgraded to 2.2.8 I am getting a Parse error: parse error in /www/g/groove_salad/htdocs/forum/vbindex.php on line 191

Can you tell me how to uninstall 2.0.1 and 2.1 RC 2 completely so I can start over?

NTLDR 10-23-2002 10:37 PM

Quote:

Originally posted by groovesalad
Can you tell me how to uninstall 2.0.1 and 2.1 RC 2 completely so I can start over?
There is an uninstaller provided in RC2 vbi_install.php

Chris M 10-23-2002 10:50 PM

@groovesalad - Perhaps if you posted the parse error, we could help you fix it:)

Satan

groovesalad 10-24-2002 12:35 AM

Parse error: parse error in /www/g/groove_salad/htdocs/forum/vbindex.php on line 191

posted it above :)

LightBringer 10-24-2002 04:26 AM

Hey NTLDR, I don't suppose you're taking requests for features to be included in vbindex are ya? :)

NTLDR 10-24-2002 11:34 AM

Quote:

Originally posted by LightBringer
Hey NTLDR, I don't suppose you're taking requests for features to be included in vbindex are ya? :)
Indeed I am :D I'm allways looking out for good extra features that can be included.

I will be starting work on my full blown portal system in the next few weeks as part of my University Degree so any ideas let me know ;)

NTLDR 10-24-2002 11:35 AM

Quote:

Originally posted by groovesalad
Parse error: parse error in /www/g/groove_salad/htdocs/forum/vbindex.php on line 191
hellstatan meant what code is on line 191 (and just above/below) ;)

Buddha 10-24-2002 01:01 PM

not to rush you ntldr... just curious... any word on when you'll be releasing the final?

NTLDR 10-24-2002 01:07 PM

Hopefully tonight or tomorrow, I've just got the instructions for the install to write up now then its all done ;)

Chris M 10-24-2002 01:17 PM

Cool:)

I cant wait;)

Satan

LightBringer 10-24-2002 01:36 PM

Quote:

Originally posted by NTLDR


Indeed I am :D I'm allways looking out for good extra features that can be included.

I will be starting work on my full blown portal system in the next few weeks as part of my University Degree so any ideas let me know ;)

An image or picture of the day box that pulls the pics from a specified forum and resizes via GD functions and displays the pic on the front vbindex page in a nice, neat, box.

Formatted for caption and description, and when the image is clicked, either a template with the full blown image is shown, or even just a javascript window would be cool.

:)

Chris M 10-24-2002 01:43 PM

Hmmm...

How about something like a Staff Members Box or something?

Satan

NTLDR 10-24-2002 02:00 PM

Quote:

Originally posted by LightBringer
An image or picture of the day box that pulls the pics from a specified forum and resizes via GD functions and displays the pic on the front vbindex page in a nice, neat, box.
Nice idea, I like it :D I'll look into this one. Not sure if I can test it very well as I don't know if GD works properly on my server, but I'll look into it.

NTLDR 10-24-2002 02:02 PM

Quote:

Originally posted by hellsatan
How about something like a Staff Members Box or something?
Should be pretty easy and its only a one query job, I may add this in before the 2.1 final :D

Chris M 10-24-2002 02:06 PM

Cool:)

Satan

LightBringer 10-24-2002 02:08 PM

Quote:

Originally posted by NTLDR


Nice idea, I like it :D I'll look into this one. Not sure if I can test it very well as I don't know if GD works properly on my server, but I'll look into it.

I second Hellsatan...."cool"!

Buddha 10-24-2002 02:18 PM

Quote:

Originally posted by NTLDR
Hopefully tonight or tomorrow, I've just got the instructions for the install to write up now then its all done ;)
excellent. i've been holding off on my other styles, as i don't have to be changing too many extra sets of templates.

looking forward to it.

groovesalad 10-24-2002 11:43 PM

Quote:

Originally posted by NTLDR


hellstatan meant what code is on line 191 (and just above/below) ;)

Well, here's what I seemed to have figured out. I uploaded the vbi_install.php file for the RC2 vbindex. I clicked to uninstall 2.1 completely and it said it uninstalled it correctly.

So then I clicked on upgrade from 2.0.1 and here is what I got.

Quote:

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: ALTER TABLE thread ADD tpostid int( 10 ) unsigned DEFAULT '0' NOT NULL
mysql error: Duplicate column name 'tpostid'

mysql error number: 1060

Date: Thursday 24th of October 2002 05:42:48 PM
Script: http://groove-salad.com/forum/forum/...tep=upgrade201
Referer: http://www.groove-salad.com/forum/admin/vbi_install.php
Not sure how to uninstall 2.0.1 after I uninstall 2.1. Any ideas?

LightBringer 10-25-2002 12:30 AM

Groovesalad,


Code:

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: ALTER TABLE thread ADD tpostid int( 10 ) unsigned DEFAULT '0' NOT NULL
mysql error: Duplicate column name 'tpostid'

mysql error number: 1060

Date: Thursday 24th of October 2002 05:42:48 PM
Script: http://groove-salad.com/forum/forum...step=upgrade201
Referer: http://www.groove-salad.com/forum/admin/vbi_install.php


What this code is telling you is that MYSQL is attempting to alter a table known as THREAD by adding a column called TPOSTID to it. Notice the error: "Duplicate column name 'tpostid'"?
This means that it already exists.

Here's what you do:
Go into myphpadmin or sql server admin of choice, drop that table.

Run the install for 2.1 THEN do setpostid.php if and only if your news doesn't show up.

Hope that helps.


All times are GMT. The time now is 09:34 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.02676 seconds
  • Memory Usage 1,825KB
  • 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
  • (1)bbcode_code_printable
  • (14)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
  • (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