When attempting to access "Content Management"... [SOLVED]

[Thomas C]

Install went fine and everything seems great, however, when I'm trying to access "Content Management" I get this error

                                  DB function failed with error number 1
           Can't create/write to file '\TEMP\#sql_84_0.MYI' (Errcode: 2)


Any ideas?

Thanks.

[datahell]

It seems that your database is not configured properly and. sql_84_0.MYI is a mysql file. Open your database with phpmyadmin, Query Browser or any other db tool you use and see if all the tables are fine.

[Thomas C]

Thank-you for replying.

The other admin functions work fine... only the Content Management and All Content Items give an error.

mySQL has been working fine for a while WRT other mySQL/PHP projects, so it's not new for this project.

Phpmyadmin shows no problems. Of course, if a certain table didn't get created I wouldn't have any way of knowing.

However, some additional info has shown up; my Apache error.log shows this;

               "File does not exist: D:/Data/htdocs/******/administrator/components/com_media/js/normal.js,"

I take it "js" means javascript. Would this be the problem? And if so, where can I get a copy of this script? A search shows it's not on my drive.

[datahell]

No the JS file could never generate that error but this shows that there are missing files from your elxis installation. To solve this problem follow the steps bellow.

1. Make sure the folder "administrator/tools/updiag/data/hashes/" is writable (permissions 777).
2. Login to Elxis administration and go to tools.
3. Go to the "Updiag" tool.
4. Click on Maintenance -> Download Hash files.
5. Download the elxis 2008.0 normal hash file.
6. Check your elxis filesystem by comparing it with the Elxis hash file (check filesystem).
7. For each file it says you that is missing or needs update, add/update it from the Elxis 2008.0 official release package.

[Thomas C]

OK.

I did that and I got;

          "Site is up-to-date!"

Also, I went into the original zipped file elxis_2008.0_Olympus_rev1891.zip and looked for the missing normal.js and it wasn't in there either.

So I'm assuming that that file is generated on the fly?

And... doesn't the admin menu system use the same procedure to call all its functions? Meaning, shouldn't pushing any of the admin buttons generate the same mySQL error that I mentioned in my initial post? as opposed to just the "Categories Manage" and the "All Content Items" buttons?

Just a few thoughts...

... and BTW, I otherwise love your setup. I think you've done a great job!

P.S.
Just some additional info, the referrer to the normal.js is...

             referer: /administrator/index2.php?option=com_media

[datahell]

OK you did n't found any file missing but at least we now know that your Elxis installation is fine.

From a little search I did in google I see that this problem is related to a something occurred during your mysql installation. Open my.cnf and try to find something that has value of "\TEMP\" or something like that (must be a temporary folder). Change it to an existing folder and make it writable to the WWW user. Re-start mysql and see if the problem solved. if not, search the internet to find a better solution or re-install mysql.

http://forums.mysql.com/read.php?52,89672,89672
http://forum.uniformserver.com/index.php?showtopic=1171

[Thomas C]

OK.

I did the "temp" dir check in my my.cnf file before posting. All is fine there.

There must be something peculiar with this particular mySQL compile.

I'll find it.

Thank-you for your help.

[Thomas C]

Problem solved...

It wasn't simply a matter of adding a "temp" directory to "my.cnf" rather adding the following line:

            slave_load_tmpdir=G:/tmp/mysql

Of course, for anyone's given setup "G:" will be wherever they choose to put their "temp" dir.

Thanks again datahell for the help and the pointer to the solution.

[datahell]

Of course, you write the full path to the temporary directory.
If you were on linux you would enter something like this: /tmp, so the "G:/tmp/..." is for windows. Of course you can set it to any existing and writable directory in your system.

[Thomas C]

As a follow-up;

Adding that path to my.cnf file pseudo fixed it. Meaning it worked, but about 50% of the time it didn't. It worked well enough that a short test showed it as fixed. It wasn't

I did solve the problem though, and I've had a day or so of heavy Elxis configuring to test it. It hasn't failed since.

What I had to do was to add a "Temp" directory into the mySQL data directory, (that is located as per individual setup).

I suspect that this is specific to the particular compile of AMP, (Apache, mySQL, PHP), that I'm using, though "who knows" as I have no way to test it.

I chatted to the compiler, but he's down with the flu and wasn't up to the questions, (who could blame him?).

With respect to the "G:\temp" and windows, I wouldn't know as I have never run a windows machine other than for some games I played in my younger, less smart, years. 

Today, windows is a total waste of my precious time.

Relative paths work here as well as full paths as I'm using the resource-light and super powerful eComStation 2.0 rc 4 where Elxis runs very well; slick and fast!

I've ran many a forum and CMS over the years, many versions of Mambo and all the version of Joomla, (plus many other CMS'), Elxis is the best of them all.

Thanks again for you good work and kind help! 

[datahell]

Thanks Thomas. We continuously try to make Elxis even better and best choice for more people.