vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Major Additions - Discuss!! A Yahoo Answers Clone (https://vborg.vbsupport.ru/showthread.php?t=281692)

jaderollie 05-23-2012 11:07 PM

Ill be adding this to my magic forum, as it will be ideal on helping magicians who need answers to an effect, or move

whitetigergrowl 05-27-2012 02:28 AM

Uninstalling is leaving things behind that when you try to re-install spits out SQL errors because it never properly uninstalled. This is on a stock VB 2.4. Errors which have been posted previously in the past few or so pages. Is there an SQL command that can help rid the sql database of content left behind by this plug-in?

ru55ian 05-27-2012 04:30 AM

There is an issue with permissions. When set for guests to be able to ask questions, however moderate them, it post questions without moderation queue. Please resolve.

Also, would be great to have a widget for cms with latest questions.

Awesome mod though.

cstreater 05-27-2012 11:41 PM

Quote:

Originally Posted by whitetigergrowl (Post 2333356)
Uninstalling is leaving things behind that when you try to re-install spits out SQL errors because it never properly uninstalled. This is on a stock VB 2.4. Errors which have been posted previously in the past few or so pages. Is there an SQL command that can help rid the sql database of content left behind by this plug-in?

Ditto. It leaves behind the discuss_categories, discuss_questions, discuss_replies, and discuss_watch tables. If you don't, you will get database errors if you try to re-install, plus it isn't good to leave these tables anyway.

You'll need open your SQL manager and drop each of them.

BACKUP first!

Christos Teriakis 05-28-2012 04:13 AM

Quote:

Originally Posted by cstreater (Post 2333696)
Ditto. It leaves behind the discuss_categories, discuss_questions, discuss_replies, and discuss_watch tables. If you don't, you will get database errors if you try to re-install, plus it isn't good to leave these tables anyway.

You'll need open your SQL manager and drop each of them.

BACKUP first!

It does not leaves back anything. A simple look in product-discuss.xml can prove it:
Code:

        $vbulletin->db->query_write("DROP TABLE
                        `". TABLE_PREFIX ."discuss_categories`, `". TABLE_PREFIX ."discuss_questions`,
                        `". TABLE_PREFIX ."discuss_replies`, `". TABLE_PREFIX ."discuss_watch`
        ");

Just now I tried once more to install and uninstall it, checking the database with phpMyAdmin. Tables created correctly and removed after uninstallation.
Please look somewhere else to find the reason that the tables didn't removed.

Chris

whitetigergrowl 05-28-2012 05:44 AM

Quote:

Originally Posted by ChrisTERiS (Post 2333790)
It does not leaves back anything. A simple look in product-discuss.xml can prove it:
Code:

        $vbulletin->db->query_write("DROP TABLE
                        `". TABLE_PREFIX ."discuss_categories`, `". TABLE_PREFIX ."discuss_questions`,
                        `". TABLE_PREFIX ."discuss_replies`, `". TABLE_PREFIX ."discuss_watch`
        ");

Just now I tried once more to install and uninstall it, checking the database with phpMyAdmin. Tables created correctly and removed after uninstallation.
Please look somewhere else to find the reason that the tables didn't removed.

Chris

Posting xml coding doesn't prove that its uninstalling anything. Especially on newer software.

Yes the software uninstalls from the forum. BUT when the software is re-installed, the sql errors are spit out because of the sql tables being left behind. It's not mine or VBulletins fault. I simply just do the uninstall from VBulletin. So who else could we talk to?

So even though mine was done on a stock version of the VBulletin 4.2 software, and obviously VB won't support this, then who else does since it's obvious you feel hassled to.

What version of VBulletin did you test this on? Is this 100% confirmed to be 4.2 compliant? For future reference.

Your post almost seems to blame us. What's funny is you are saying this is supported above, yet tell us to go somewhere else to get support. Amusing.

When mine was done on STOCK (no other mods or template edits at the time and using the stock skin) VBulletin 4.2 software I uninstalled it because the navbar link was not showing up so I figured if I uninstall and re-install it maybe it would be fixed. When I went to re-install it is when the sql errors occured. And that is when I found out from coming back here and searching in this thread that another user or 2 posted with the same problem, and I saw for myself, was the sql code was left behind.

Also, its leaving a 'discuss' in the usergroups that that SQL coding is obviously also not removing. Because if you remove those by themselves....the 'discuss' entry is still left in the Usergroups. When you delete it it stays gone. That is until you try re-adding this plug-in. Once you try re-adding this plug-in it automatically re-adds those sql.

Keep in mind this is the ONLY plug-in I have had this issue with.

Christos Teriakis 05-28-2012 06:32 AM

Quote:

Originally Posted by whitetigergrowl (Post 2333799)
Posting xml coding doesn't prove that its uninstalling anything. Especially on newer software.

Posting the xml code (and of course checking that really this code exists in your file, proves that there is no coding error.

Quote:

Originally Posted by whitetigergrowl (Post 2333799)
Yes the software uninstalls from the forum. BUT when the software is re-installed, the sql errors are spit out because of the sql tables being left behind. It's not mine or VBulletins fault. I simply just do the uninstall from VBulletin. So who else could we talk to?

Even a simple server down at the time of uninstallation can be the reason that uninstallation fails.

Quote:

Originally Posted by whitetigergrowl (Post 2333799)
So even though mine was done on a stock version of the VBulletin 4.2 software, and obviously VB won't support this, then who else does since it's obvious you feel hassled to.

You post at 03:41am my time (hope that you're permitting me to sleep at nights), and I replied at 08:12am, which means 13 minutes after the time that I came online. So I'm supporting you.

Quote:

Originally Posted by whitetigergrowl (Post 2333799)
What version of VBulletin did you test this on? Is this 100% confirmed to be 4.2 compliant? For future reference.

If you give a minute to read the details, you'll find out that says: "vB Version: 4.1.11". Not even 4.1.12. So don't asking if its confirmed for 4.2 compliant.

Quote:

Originally Posted by whitetigergrowl (Post 2333799)
Your post almost seems to blame us. What's funny is you are saying this is supported above, yet tell us to go somewhere else to get support. Amusing.

My second reply to your questions shows that I'm supporting it. But for issues that are coming from wrong code etc. Not for issues that you maybe have in your server, or in your vb installation, or (most probably this is the issue) from the vb version that you're using.

Quote:

Originally Posted by whitetigergrowl (Post 2333799)
I uninstalled it because the navbar link was not showing up so I figured if I uninstall and re-install it maybe it would be fixed.

All mods here which are using tabs and menus are having incompatibilities with 4.2 as vb is using a totally different way for navbar in this version. I'm working on this, just keep in mind that I've more than 10 mods to fix.

Quote:

Originally Posted by whitetigergrowl (Post 2333799)
When I went to re-install it is when the sql errors occured. And that is when I found out from coming back here and searching in this thread that another user or 2 posted with the same problem, and I saw for myself, was the sql code was left behind.
Also, its leaving a 'discuss' in the usergroups that that SQL coding is obviously also not removing. Because if you remove those by themselves....the 'discuss' entry is still left in the Usergroups. When you delete it it stays gone. That is until you try re-adding this plug-in. Once you try re-adding this plug-in it automatically re-adds those sql.

Keep in mind this is the ONLY plug-in I have had this issue with.

If the uninstallation failed, then ALL the database changes left behind. For your refference (but only if you're familiar with phpMyAdmin), there are 4 tables and 3 fields to remove:

1.- Tables

discuss_categories
discuss_questions
discuss_replies
discuss_watch

2.- Fields

a] Discuss in table usergroups
b] discuss_questions in table user
c] discuss_replies in table user

Chris

whitetigergrowl 05-28-2012 06:44 AM

Quote:

Even a simple server down at the time of uninstallation can be the reason that uninstallation fails.
Which would be great but the server has never been down and has never experienced problems with SQL. EVER. While it's not impossible, it's pretty unlikely.
Quote:

You post at 03:41am my time (hope that you're permitting me to sleep at nights), and I replied at 08:12am, which means 13 minutes after the time that I came online. So I'm supporting you.
But telling us to go somewhere else for the answer is NOT supporting us after telling us it uninstalled and re-installed fine for you. Anyone can give a vague or simple answer. Especially to just go elsewhere for help.

Actually helping figure out why its only your plug-in that I have used that is experiencing this issue would be support. While 4.2 may be the issue...there are other 'not quite yet updated' plug-ins that have installed and uninstalled just fine on 4.2 for me and not experienced the same problem with them.

Quote:

If you give a minute to read the details, you'll find out that says: "vB Version: 4.1.11". Not even 4.1.12. So don't asking if its confirmed for 4.2 compliant.
And I was clear in my first post that I was using 4.2 stock at the time. When you responded you never stated what version of VB you used to do your test on. And you never stated 4.2 was the likely problem. But to just go somewhere else for support.

Quote:

My second reply to your questions shows that I'm supporting it. But for issues that are coming from wrong code etc. Not for issues that you maybe have in your server, or in your vb installation, or (most probably this is the issue) from the vb version that you're using.
While my issue was with 4.2....I can't vouch the others with the same issue what VB version they were using, but they at a minimum experienced the same things left on the server after uninstall. But I was not the only one.

Quote:

All mods here which are using tabs and menus are having incompatibilities with 4.2 as vb is using a totally different way for navbar in this version. I'm working on this, just keep in mind that I've more than 10 mods to fix.
Fair enough.

Quote:

If the uninstallation failed, then ALL the database changes left behind. For your refference (but only if you're familiar with phpMyAdmin), there are 4 tables and 3 fields to remove:

1.- Tables

discuss_categories
discuss_questions
discuss_replies
discuss_watch

2.- Fields

a] Discuss in table usergroups
b] discuss_questions in table user
c] discuss_replies in table user
Thank you. I had already deleted the Tables...just gotta dig up the Fields but those will have to wait until tomorrow as it's too late tonight for me to get rid of them.

cstreater 05-30-2012 05:03 AM

I don't know about all of that. I installed as instructed & then uninstalled. I then re-installed, and started getting database errors that tables already existed. I found that the uninstaller had left all 4-tables behind. Believe me or not, it's a fresh 4.2 test environment.

Christos Teriakis 05-30-2012 05:13 AM

Please don't try it in vB4.2. I haven't checked it there. The max checked and compatible version is 4.1.12

Chris


All times are GMT. The time now is 06:19 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.01342 seconds
  • Memory Usage 1,790KB
  • 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
  • (16)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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