Author Topic: I have completely scrooched (thank you Rocky&Bullwinkle) all my installations (Read 3744 times)

JonWex · November 26, 2011, 06:10:47 pm

Joomlav1.5 Windows-Apache-MySQL-PHP CiviCRM 3.3.3

I have fouled up all my installs - one of them thinks (for good reason) that it was installed at a different URL than the one it is being accessed at

Another says "DB Error - Missing table" and provides no further insight - where/what is the database it is looking at?? can I uninstall and reinstall??

Part of my issue is that I do Joomla backups by copying through the Windows file system and changing a few pointers. I now suspect this is a non-starter for the CiviCRM things - is there a way to do this??

Thanks

Jonathan

EdP · November 27, 2011, 10:26:22 am

Well, if you have moved the domain that the install is on, but not updated the settings files then yes, it will be confused. The settings files (civicrm.settings.php) will record the base URL that it expect to be running off. Correct that (in /components/com_civicrm and /administrator/components/com_civicrm) and then use the various settings pages in the admin page within CiviCRM to update filepaths for php, file storage etc.

It should be happier after that.

The database Civi is looking for is (by default) the database that your Joomla install is in, but with tables starting civicrm_ or similar (if your civi db is elsewhere, update the civicrm.settings.php files - likewise if those files weren't pointing to localhost and therefore say something odd). As for which specific table it is looking for - it should tell you but failing that do a clean install (NOT on top of your current one, obv, as that will mess up your existing Civi install - on a backup) and compare that db to yours to see what you are missing. There are instructions about for dealing with failed installs.

JonWex · November 27, 2011, 02:07:23 pm

Edp

Thanks for your response. I have eliminated the "wrong URL" message, and think I have a shot at successfully cloning.

So, now all my installs claim "missing table". I have 134 civicrm_*.frm schema files in with the joomla tables, but no civicrm_*.my? files.

Two theories
1) Are the CiviCRM scripts looking in the wrong place? The settings file has
define( 'CIVICRM_UF_DSN' , 'mysql://root:@localhost/acr2?new_link=true' );
which makes at least a modicum of sense

2) Does MySQL build .myd and .myi files from the schema if the data and index files are not present, or does the CiviCRM installer need to do this? (I can half-explain how the .myd and .myi files might have gone away)

Thanks in advance

Jonathan

Donald Lobo · November 27, 2011, 03:23:14 pm

CiviCRM uses innodb tables which do not use any *.my? or *.frm files (MyISAM does)

lobo

JonWex · November 27, 2011, 06:22:48 pm

Gents -

I did a little reading on innodb, and am a clueless as to how to fix it (or CiviCRM's linkages to it) without deleting/uninstalling everything and starting over.
I am being a little lazy .. I know there is a command line inteface for MySQL, but I forget how to get at it, and I have little idea of what I would ask it for.

So, if you have any feedback on what I am seeing or not seeing

In wamp/www/bin/mySql/mySql5.5.8/data, I have
a) folders with names like "ac" "acr2", "joomla15" which i recognize as names I specified during the various joomla installs I did
b) a file named ibdata1 and a series of files named mysql-bin.00000<n> which I assume are innodb storage - I am a little concerned that it would try to hold both the "ac" and "acr2" databases - I may have caused great confustion between those two (both of those may have harbored the name "ac" in critical places)

I do not see any other files in the neighborhood that look like candidates to hold innodb data and indices.

Jonathan

Hershel · November 28, 2011, 04:54:40 am

I would not recommend (at all) that you attempt to examine a MySQL database via looking at the files. I recommend phpMyAdmin, or you can find a suitable GUI for Macintosh. Using either of those, you can see clearly what tables exist, what don't, and whether or not your MySQL is set to allow InnoDB.

Sounds to me, however, that a reinstall is without question, the simplest solution.

JonWex · November 28, 2011, 07:34:07 pm

"I see" said the blind man ...

I have one complete set of civicrm tables, and it is linked to by one of my sites. Unfortunately, these tables contain a few hundred occurences of text that looks like "/a_Different_site/administrator/index2.php", and I suspect this is a bad thing. I may try to fix this, because the notes I took on civiCRM settings are very incomplete.

A related thought - how does one clone a Joomla site that has a civiCRM component installed. I am pretty addicted to cloning (given my incompetence and a "client" that does not really provide any direction"). I am also developing on a server on my LAN, with the thought of uploading to some hosting service that does not have one zillion sites per physical server (that is, avoid GoDaddy); the uploading seems a lot less straightforward than it did a week ago.

Thanks for your patience.

Jonathan

Hershel · November 28, 2011, 07:57:14 pm

> A related thought - how does one clone a Joomla site that has a civiCRM component installed.

Directions are here:

http://wiki.civicrm.org/confluence/display/CRMDOC40/Moving+an+Existing+Installation+to+a+New+Server+or+Location

JonWex · November 29, 2011, 02:28:22 pm

Thanks - I think I have the general gist of this.

I think I want to try fixing the existing installs, so I may wind up with more questions.

But, I have been called away to other issues, so it will likely be days before I am back to this

Thanks again,

Jonathan

JonWex · December 09, 2011, 10:22:08 am

So I gave up trying to fix the existing sites, so now I am trying to unistall-reinstall v3.3.3.

I can get the uninstall and reinstall procedures to run to completion (at least twice), but the administrator UI menu is messed up (the options appear on the left as text, and there is a mouse flyover reaction in that area, but not one that is usable) see attached.

I have tried civicrm/menu/rebuild&reset=1 and civicrm/admin/settings/updateConfigBackend&reset=1 and every other curative
measure I can think of without success.

Any quick fixes??

Hershel · December 10, 2011, 11:35:36 am

Can you check the Net tab of Firebug for Firefox and see if any CSS or JS files are not being loaded?

JonWex · December 10, 2011, 01:43:57 pm

Slightly different failure in Firefox (vs IE9). Error log attached (converted to greyscale)

Thanks

Jonathan

Hershel · December 12, 2011, 06:36:09 am

Hard to read your file, but seems clear that your install is not finding some JS files. Can you check on those files on the server?

JonWex · December 12, 2011, 06:55:15 pm

So I thought I had Firebug installed, but I did not. After some installing it and futzing around, I found some useful error messages (see attached).

I am guessing that it is not finding the jquery.js file (which is actually where it should be) because there is a '\' character in the filepath(URL esacpe code %5C).

How do I go about fixing that (some xyz_spqr.settings.php file)?

Thanks

Jonathan

Hershel · December 14, 2011, 05:59:26 am

Visit civicrm/admin/setting/updateConfigBackend&reset=1

CiviCRM Community Forums (archive)

News:

Author Topic: I have completely scrooched (thank you Rocky&Bullwinkle) all my installations (Read 3744 times)

JonWex

I have completely scrooched (thank you Rocky&Bullwinkle) all my installations

EdP

Re: I have completely scrooched (thank you Rocky&Bullwinkle) all my installations

JonWex

Re: I have completely scrooched (thank you Rocky&Bullwinkle) all my installations

Donald Lobo

Re: I have completely scrooched (thank you Rocky&Bullwinkle) all my installations

JonWex

Re: I have completely scrooched (thank you Rocky&Bullwinkle) all my installations

Hershel

Re: I have completely scrooched (thank you Rocky&Bullwinkle) all my installations

JonWex

Re: I have completely scrooched (thank you Rocky&Bullwinkle) all my installations

Hershel

Re: I have completely scrooched (thank you Rocky&Bullwinkle) all my installations

JonWex

Re: I have completely scrooched (thank you Rocky&Bullwinkle) all my installations

JonWex

Re: I have completely scrooched (thank you Rocky&Bullwinkle) all my installations

Hershel

Re: I have completely scrooched (thank you Rocky&Bullwinkle) all my installations

JonWex

Re: I have completely scrooched (thank you Rocky&Bullwinkle) all my installations

Hershel

Re: I have completely scrooched (thank you Rocky&Bullwinkle) all my installations

JonWex

Re: I have completely scrooched (thank you Rocky&Bullwinkle) all my installations

Hershel

Re: I have completely scrooched (thank you Rocky&Bullwinkle) all my installations