vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Removing Hacks for 3.5.4 to 3.6 (https://vborg.vbsupport.ru/showthread.php?t=123620)

johnstires 08-10-2006 11:41 PM

Removing Hacks for 3.5.4 to 3.6
 
I am practicing upgrading my site and am following this thread's directions:

http://www.vbulletin.com/forum/showthread.php?t=187770

I am stuck at this part:
Quote:

Removing hacks: It's at this stage if you have hacks on your database, you can remove them from this test duplicate copy of your database you just created in step 3 - which has your imported back up sql file from step 4. This leaves all hacks and php edits intact on your live original database untouched. All you are doing is removing hacks and php edits from a copy of your original database
I don't understand what it means to remove hacks.

I currently have vba cmps and GARS as large add-ons. I also have some minor php hacks which I probably forget and some template modifications.

How does one remove hacks?

Paul M 08-11-2006 12:18 AM

By reversing the install instructions for them.

johnstires 08-11-2006 12:44 AM

Sorry to be a bit thick here, there is some core element that is eluding me.

I have kept track of the add-ons and php hacks that I did: vba cmps, GARS and some minor php edits.

By
Quote:

"remove them (hacks) from this test duplicate copy of your database"
does that mean I delete the mysql tables from the hacks that are in my new temp database?

Quote:

"All you are doing is removing hacks and php edits from a copy of your original database"
How do I remove php edits from the copy of my database? My database doesn't have php hacks, my php files have hacks. And I can't edit those because tthe php files in my temp database are all v 3.6? Those php files are brand new. THey have never been edited.

Paul M 08-11-2006 01:01 AM

Quote:

Originally Posted by johnstires
By does that mean I delete the mysql tables from the hacks that are in my new temp database?

If the hacks created their own tables then yes, you can delete (drop) them - however, this isn't necessary as they won't harm anything (unless of course they happen to have a name that clashes with a new vb table, but that's unlikely).

Quote:

Originally Posted by johnstires
How do I remove php edits from the copy of my database? My database doesn't have php hacks, my php files have hacks. And I can't edit those because tthe php files in my temp database are all v 3.6? Those php files are brand new. THey have never been edited.

You cannot "remove php edits from the copy of my database" because as you say, that statement makes no sense. I assume it means remove the php edits you made to files - and again, as you say, if you have uploaded the fresh 3.6 files then that step isn't necessary as the fresh files will not have any edits.

johnstires 08-11-2006 01:16 AM

So what I really should do is skip that step. Install the board on my second temp directory. Then install my new hacks and edit my php files on my new directory. Then edit my templates as necessary.

Paul M 08-11-2006 01:39 AM

Sounds like a plan.

johnstires 08-11-2006 02:13 AM

okay so now I have a new problem. If I have vba cmps in my root directory along with forums and forums2 (my temp), how do I upgrade vba cmps without touching my currently live files?

Also I am getting this error on my forums2/admin/index.php

Quote:

Database error in vBulletin 3.6.0:

Invalid SQL:

SELECT adminmessage.adminmessageid
FROM adminmessage AS adminmessage
INNER JOIN adminlog AS adminlog ON (adminlog.script = adminmessage.script AND adminlog.action = adminmessage.action)
WHERE adminmessage.status = 'undone'
AND adminmessage.script <> ''
AND adminlog.dateline > adminmessage.dateline
GROUP BY adminmessage.adminmessageid;

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Date : Thursday, August 10th 2006 @ 11:11:51 PM
Script : http://localhost/forums2/admincp/index.php?do=home
Referrer : http://localhost/forums2/admincp/index.php?do=nav
IP Address :
Username : admin
Classname : vB_Database


All times are GMT. The time now is 04:15 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.01091 seconds
  • Memory Usage 1,732KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete