Forums / Install & configuration / Login / show user site 3.3.0 beta 1

Login / show user site 3.3.0 beta 1

Author Message

Karsten Jennissen

Thursday 27 November 2003 2:41:43 am

Anyone else having problems logging in to the Admin or showing the user sites?

I installed all demo sites except for corporate on a dedicated server (Suse 7.2) where 3.2.3 runs perfectly, using the setup wizard, plain English, nothing changed.

None of the user sites of the 7 installed demos work (l I get a permission denied error), except for the plain site where I can both log in as admin and see the user site.

Bård Farstad

Thursday 27 November 2003 3:04:21 am

Can you check if the databases are installed correctly? Turn on debug information and see if you get a database connection error.

--bård

Documentation: http://ez.no/doc

Karsten Jennissen

Thursday 27 November 2003 3:26:00 am

Hmm, you are right, the only database that has all the tables is the plain package one.

I tried executing the blog.sql from the kernel/setup directories and get an error message:

Output from SQL commands in file /..../kernel/setup/packages/blog/sql/mysql/blog.sql ..

ERROR 1065 at line 23: Query was empty

The only table created is the approve one. Line 23 in blog.sql:

/*!40000 ALTER TABLE ezapprove_items DISABLE KEYS */;

Doesn't seem right to me, although I am not a mysql expert. Any comments?

Karsten

Karsten Jennissen

Thursday 27 November 2003 3:31:00 am

Just a guess. Could it be because of different mysql versions? I am still using 3.23.37 and this was a 4.1 dump.

Bård Farstad

Thursday 27 November 2003 3:35:04 am

Karsten you're probably right. We've not tested on that old MySQL. We will fix this. You can just remove these comments from the SQL files and it should run fine.

Thanks for the notice,

-bård

Documentation: http://ez.no/doc

Karsten Jennissen

Thursday 27 November 2003 4:08:20 am

The quickest fix is which search & replace. Just add '-- ' (without '') before each /*!... line.

Hans Melis

Thursday 27 November 2003 5:22:26 am

Shouldn't MySQL just skip that /*!40000.....*/ line?

I don't know the meaning of /*!40000 in great details, but I thought it meant something along the lines of: "don't execute this, unless the mysql version number >= 4.00.00"

Or am I wrong?

--
Hans

Hans
http://blog.hansmelis.be