Loading...
 
Architecture / Installation

Architecture / Installation


Database and other trouble after Fantastico upgrade of 2.4 to 3.0

posts: 18

The Fantastico option to upgrade my TikiWiki 2.4 site to TikiWiki 3.0 was available this morning. After backing up the database and key file directories, I tried it.

Fantastico said it successfully did a backup, replaced the files, and upgraded the database, but TikiWiki doesn't seem to think that the database has been upgraded.

On the home page, I have a bunch of PHP errors, boiling down to 3 unique problems:

Undefined variable: tiki_p_trust_input
Undefined index: query
Undefined index: feature_check

On the admin page, I see:
-------
Database Version Problem
Your database requires an update to match the current TikiWiki version. Please proceed to the installer. Using Tiki with an incorrect database version usually provoke errors.
-------

When I follow the link, I'm told that I "don't have permission to access /tiki-install.php on this server." I am logged in as a member of the administrators group, so I should have permission.

When at look at the file permissions for /tiki-install.php with my FTP client, they seem to be OK. Deleting the db/lock file didn't help me.

I'm stuck. I suspect that there was a missing SQL update script in the Fantastico upgrade sequence, but I don't know where to look.

I'm able to view the schema and run SQL statements against my database remotely. If there are things I should check or scripts I should run, please let me know.

I'm using the tikinewt style.

Other symptoms:

I have lost my structures. TikiWiki thinks this option is disabled, and I can't find the option to re-enable it. This may be because of the database problem, or not. I had a *lot* of pages in structures in 2.4, and I really need to have them back.

I have lost my full-text search box. It used to be at the top right of the page. I did find the search option and re-enabled it, but the "Find in entire site" box hasn't come back.

posts: 1092

> I have lost my structures.
tiki3 has a problem, you must manually check admin->wiki -> features -> structures

> I have lost my full-text search box.
Check admin-> look -> search bar - perhaps the setting is off
Do not foget there is a permssion tiki_p_search

>tiki-install.php - no idea but for sure you have to upgrade your database - all the scripts that must be run to upgrade your database are in the diretory installer/schema
tiki-install.php must be readeable by the server (some hosting asks to have the file non writeable by the server too)

posts: 18

Thanks! Your first suggestion worked, and got my structures back. The admin/wiki/features page looks buggy, though.

The search bar was already active, and the permission was set. I still don't have a search bar.

I'll try running the schema scripts and see what happens.


posts: 5

I had a similar set of problems when I upgraded with Fantastico. Only "Admin" could see the site at all. All other users were told that the database needed to be upgraded, with an sql error reported on the front page. Admin could not reach the 'tiki-install.php' page, same error actually for all users.

I restored the site from the backup, I am very interested in knowing if the suggested resolution here works.

posts: 18

My TikiWiki 3.0 site is working now. Thanks, Sylvie, for the help.

I had to ask my ISP to whitelist my site for all the mod_security rules that were blocking the installer. Then I was able to run the installer and upgrade the database. I had to open up db/local.php on the site to find the generated DB password to get by the security check.

I do have a few PHP errors now, but I'll create new topics for them to make them easier to track.

posts: 5

I've got a copy of the upgraded site available, but I cannot get to the tiki-install.php script. It gives me the message

Your IP x.x.x.x is forbidden from reaching this portion of the site.


I have changed all permissions to read / execute and disabled the htaccess (they are all named _htaccess per the documentation, not .htaccess.

Any suggestions?


posts: 5

I've got a copy of the upgraded site available, but I cannot get to the tiki-install.php script. It gives me the message

Your IP x.x.x.x is forbidden from reaching this portion of the site.


I have changed all permissions to read / execute and disabled the htaccess (they are all named _htaccess per the documentation, not .htaccess.

Any suggestions?

(reposting, my first reply seems to not show up?)


posts: 18

Ask your ISP to whitelist your IP address and/or the mod_security rules that are blocking you from reaching the installer. You don't have control over those things.

The permissions should have been 755. That's not a problem.

_htaccess is ignored. Copy or rename the one in the root to .htaccess, and Apache will use the rules.

posts: 5

That worked great! The test version of the wiki is running fine. I am ready to try this on the real thing.

Thanks so much for the help!