Loading...
 
Skip to main content

Architecture / Installation


unable to connect to database installation errors

I have searched through the forums as well as googled this particular set of errors and I have been unable to find anything that addresses my particular situation and set of errors.

After following the installation directions to what has seemed to be the letter and this is TikiWiki v. 2.2, and then running the TikiWiki installer(.php), I unable to connect to database 'db_name.users does not exist'. I have checked my permissions and usernames dbnames and passwords for the databse login and everything seems to be in order as far as that is concerned.

216 SQL queries installed successfully but 1120 operations failed, the vast majority.

My database has only three tables in it at this point that I can see from MyPHPAdmin tiki_dynamic_variables, tiki_minichat, and tiki_pages_translation_bits.

Something in the translation script as it relates to connecting to the database is not properly aligned or in order at this point.

Any insight into where I can look to fix this or modify the files.

Surely, I cannot be the only person to experience this particular error.

Yes, I have used localhost as connection and that is where the database sits. My hosting company is very advanced and there's plenty of memory and current versions of MySQL and PHP with the Apache server. I really doubt that the difficulty lies there.


Thanks in advance for any assistance you can supply.

Thanks, Joe😕


🎅 Well, TikiWiki CMS/Groupware v1.9.11 worked just fine. Installed first time, no problems.

My recommendation to anyone suffering similar problems with v2.2 would be to rollback to v 1.9.11 or one of the older versions.

Not only was it fairly clear that the v2.2 install script was failing to properly connect to the database as I mentioned above, but the most crude, simple first pass debugging code I placed confirmed it, AND despite the fact that the database and connectivity were fully intact, as I suspected.

In fact, I remain a bit shocked that I have not seen more postings with my specific problem. At least you all can see that the collective's steering committee has admitted that users are mentioning a lot of installation problems with v.2.2 (Hint: in addition to chastising the users into double-checking their setups and procedures, how about doing a bit more QA testing of the installation process😉 )

I am wondering about those who were able to successfully install v2.2 on their own. You guys out there? Maybe you can help.

If I find time, maybe I can help offer a fix, but the reason I went with TikiWiki was that I would have a nice, solid, QA-tested piece of working and powerful software to install for which I would not have to write a lot of code, in this instance, not even debugging code. 😀

Nevertheless, v1.9.11 works beautifully and everyone needs to remember that this is FREE open source code and these wonderful programmers are all volunteers.

Thanks, Bloozman (but no longer singin' the blues)

Using the install script isn't mandatory, if something in your situation is hanging it up. Once your Tiki files are in place and you have a database ready, you can use phpMyAdmin or another client to create and populate the tables by running db/tiki.sql for a fresh installation or the appropriate upgrade sql script(s) for an upgrade. Normally db/local.php is created during the installation process so if you can connect to the database, this file is in place; if not maybe it needs to be created or edited. You can use the file from your previous installation.

-- Gary


Thanks for trying ricks99,

I re-ran the installer many times, but I just did it, yet again, as a follow-up to your comments with, unfortunately, the same result.

I don't believe it's a connectivity issue. The installation script is clearly failing. I will try directly through an ethernet connection, but I highly doubt this is the issue.

As far as max_execution_time goes, I doubt that is it, either, but where would I change that? Searching all TikiWiki files produces only the changelog.txt that mentions that setting and that was about changing the language to French.

If you mean at the hosting site, I really doubt this hosting company, which is massively load balanced with backup servers is really suffering from any timeouts. I run five other sites from this place and I have never suffered any such problems.

Any other ideas?

My next steps will likely be
(1) placing in some debugging code into tiki-install.php to determine exactly where it's failing

(2) rolling back to an earlier version of tikiwiki to see if maybe v. 1.9.7 has a more solid install.

I am still open to suggestions.


Thanks Guys for the continued support. Chibaguy's suggestion enabled me to
shed significantly more insight into my particular problem with v2.2. Just
for the heck of it, I tried upgrading to v 2.2, after 1.911 was working.
After noticing a far greater proportion of successful queries, but still a fair
amount of errors, I implemented Chibaguy's approach using PHPMyAdmin. I
have one last annoying very specific error remaining, which I will
describe in some detail below, and maybe you guys can help me solve that
one.

Most of the errors were of the type "You have an error in your SQL syntax
near 'ENGINE=MyISAM'... ". I discovered this was a result of my hosting
company having MySQL ver 3.23.58, which I guess is a tad older version and
incompatible with 'ENGINE'. I changed all instances of 'ENGINE' to 'TYPE'
and all of those errors disappeared. {I have to recant some of my comments
as evidence is mounting that my hosting company is not quite ready for
v2.2, rather than a problem with v2.2. I guess v2.2 is not immensely
backwards compatible with older versions of MySQL. I wonder if my last
error is also related to such incompatibility.

The last hangup or the next Error, at least, is with SQL query:

DROP TABLE IF EXISTS tiki_modules;
CREATE TABLE tiki_modules(
moduleId int( 8 ) NOT NULL AUTO_INCREMENT ,
name varchar( 200 ) NOT NULL default '',
position char( 1 ) default NULL ,
ord int( 4 ) default NULL ,
TYPE char( 1 ) default NULL ,
title varchar( 255 ) default NULL ,
cache_time int( 14 ) default NULL ,
rows int( 4 ) default NULL ,
params varchar( 255 ) default NULL ,
groups text,
PRIMARY KEY ( name( 100 ) , position, ord, params( 140 ) ) ,
KEY positionType( position, TYPE ) ,
KEY moduleId( moduleId )
) TYPE = MYISAM

MySQL said: Documentation

  1. 1171 - All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead


I cannot seem to easily solve this one. I cannot seem to find syntax that
will work. Changing the declarations of NULL to NOT NULL in various
permutations is not doing it. I don't quite know the syntax for utilizing UNIQUE either.

Can you guys help with this hopefully, last specific error?


😎

I was able to get my hosting company to upgrade the database to MySQL 4.1 and then tikiwiki v2.2 installed just fine, without a single error, in fact, so that was the issue.

This issue has been resolved, and I hope the information will help others.