Bug or is it my faulty installation ?

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
2/13/2007 10:59:59 PM
Gravatar
Total Posts 2

Bug or is it my faulty installation ?

Installation was pretty easy. But I am not sure the issue I am facing is a bug with MP or a issue in my installation process.

Brief description (as I understand) : Tables PageIndex and PageIndexForUsers are referenced, but missing from Database

Detailed :

Server OS : Linux (CentOS 4.4)
Client OS : Linux (same as server :-P)
Web Server  : Linux Apache 1.3.37 / Mod_mono
Database : MySQL 4.1.21-standard
Latest Mojo portal downloaded from http://developer.novell.com/wiki/index.php/Mojoportal

Issue / Bug

Two links in homepage shows exceptions

1. Member list. On clicking the URL , I am getting the error as below

System.Exception: Unhandled Exception while processing NeatUpload child request ---> 
MySql.Data.MySqlClient.MySqlException: #42000Access denied for user 'demoweb_mp'@'localhost' to database 'demoweb_mp'

And on a refresh of the page, I get another error

MySql.Data.MySqlClient.MySqlException: #42S02Table 'demoweb_mp.PageIndexForUsers' doesn't exist

Ofcourse it has got few more lines following the exceptions, following  which I dont feel relevant here, like

  at MySql.Data.MySqlClient.PacketReader.CheckForError () [0x00000] 
at MySql.Data.MySqlClient.PacketReader.ReadHeader () [0x00000]
at MySql.Data.MySqlClient.PacketReader.OpenPacket () [0x00000]
at MySql.Data.MySqlClient.NativeDriver.Authenticate411 () [0x00000]
at MySql.Data.MySqlClient.NativeDriver.Authenticate () [0x00000]
at MySql.Data.MySqlClient.NativeDriver.Reset () [0x00000]
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection () [0x00000]


I feel it as bug because there is PageIndexForUsers table in the db. I dont see such a table in MySQL script as well. And the best part is that it has a table prefix of mp_

Access Denied is not because of the wrong pass, if they all read the same Web.config as the root installation of mojo portal.

2. Almost the same error as before, but this time with "Image Gallery" and DB missing is PageIndex.
 
MySql.Data.MySqlClient.MySqlException: #42S02Table 'demoweb_mp.PageIndex' doesn't exist
I did search for related errors, but couldn't find any. So if you can get me on a direction, that would be of really great help

Thanks
Arun
2/14/2007 7:20:07 AM
Gravatar
Total Posts 18439

Re: Bug or is it my faulty installation ?

Those tables would be temporary tables not permanent tables thats why they are not in the script.

The problem is that the user in your connection string needs permission to create temporary tables. If you grant that permission this error will go away.

Hope it helps,

Joe
2/14/2007 12:52:15 PM
Gravatar
Total Posts 2

Re: Bug or is it my faulty installation ?

   That WORKED !!!!!!!!
Happy Valentines Day!!

Thanks Joe :-)
You must sign in to post in the forums. This thread is closed to new posts.