The Joomla! Forum ™

I've been having a problem with my menus in Joomla that I don't know hot to solve. I'm not sure about what I did, but whever I add a new item, it makes itself as id 0 in the database and changes all of the other menu items to look like this ..........Home ..........Links etc., with a bunch of periods before them. Then, my whole site slows down like crazy until it's unusable and I have to re-upload my database backup. Anyone have any idea what is going on here? Should I be reporting this as a bug or did I possibly do something wrong myself?

Thanks!

Nomi

_________________
Giving shape to your concept
http://www.intuitivedesigns.net

I forgot to mention also that I'm using Joomla 1.0.8 .

_________________
Giving shape to your concept
http://www.intuitivedesigns.net

Ok, now it seems that nothing wants to work at all.

When I try to install a new component, I am getting something like this error:


I try deleted the entry '0' in my database for the jos_components table and for the jos_menu table, but when I install something else, it just creates another entry with the id 0 again.

_________________
Giving shape to your concept
http://www.intuitivedesigns.net

Check your database for errors.
Use your hosting control panel or phpMyAdmin to check and repair all your Joomla tables.

The error is very odd so I am guessing that you have some data corruption.

_________________
██ AllMedia4Joomla Project
██ http://sourceforge.net/projects/allmedia4joomla/

Thank you so much for the help. I'm feeling a little panicky here, lol.

Ok, did a repair on all of the joomla tables in my database and the result on each was ok, but I'm still having the same problem.

_________________
Giving shape to your concept
http://www.intuitivedesigns.net

The MySQL error suggests you are trying to install OpenSEF again.
That is very odd if you are simply trying to make some menu changes.


Are you sure your database backup is OK?

I took a look at your site (very nice BTW).

I see you have two languages and I am guessing you are using MambleFish.
I do not know of anyone who has MambleFish working with OpenSEF.
We have not tested it and probably will not test it until JoomFish is released.
At this point I suggest you set OpenSEF Enabled? to Off.

I also see you are using WordPress for your blog - with fancy URLs.
I am sure this requires an htaccess file from WordPress.
Using standard Joomla core SEF (and OpenSEF) requires using another htaccess file.
These htaccess files can interact with each other and cause problems.

I know the JD-WordPress bridge component does work with standard Joomla core SEF.
It is used on the Joomla Developers site for the developer blogs.
It also probably works with OpenSEF On as the JD-WordPress developer is also the OpenSEF Lead Developer.
This does not mean you would have fancy URLs, just they will not conflict.

I have not used JD-WordPress so there may be other issues.
i.e. Don't know if Permalinks work, fancy URLs, etc.
But no Joomla errors.

I assume you have some htaccess rewrite errors as the Home link from your blog pages results in a 404 error.

Some of these rewrite issues may be affecting your Joomla Administrator.
Standard Joomla core SEF has no effect on the Joomla Administrator links.
I am wondering if something you have in an htaccess file is affecting the J Administrator.

What would I do?
Turn everything Off and start adding things back one-by-one.
Turn Off WordPress fancy URLs and Permalinks.
Turn Off OpenSEF.
Turn Off standard Joomla core SEF.
No htaccess files anywhere.

Does the site work with no SEF On anywhere?

If yes, at least you have found the source of the error.
If no, it is another issue.

_________________
██ AllMedia4Joomla Project
██ http://sourceforge.net/projects/allmedia4joomla/

Also check your WordPress setup.
Once I go to the blog area
http://www.intuitivedesigns.net
becomes
http://intuitivedesigns.net

The missing "www." can cause multiple Joomla issues.

_________________
██ AllMedia4Joomla Project
██ http://sourceforge.net/projects/allmedia4joomla/

Thanks Ken, it's actually not on my own site though. It's a test site for a client here if you'd like to see it:
*link removed*

Since it's a test site, I don't mind giving you or anyone else admin access to look at it if that would help.

I do thank you greatly for the information though. I was actually considering using the jd-wordpress component for the blog. I did try open-sef too, but had another unrelated problem with that and decided not to use it, so it's not on for now, I hope! If mambelfish it would integrate one day with it, that would be cool. I really am glad you looked at it too because I didn't realize that the link from the blog to home had a 404 error.

Thank you again! I really appreciate the info.

_________________
Giving shape to your concept
http://www.intuitivedesigns.net

Also, I'm not sure if I mentioned this clearly, but it's not necessarily the open-sef component that I'm having a problem with. It's when I try to make new menus, install any component, install modules, etc. I just used the open-sef component installation as an example. I can see where that might have gotten confused.

_________________
Giving shape to your concept
http://www.intuitivedesigns.net

The webhosting provider you are using is running with MySQL 5 in strict mode.
Which is causing this problem.

You could ask your provider to switch off 'strict_mode'.

There is a way to switch this off within your site, but will require hacking your core files.



This issue will be resolved in 1.0.9, but switching off strict mode for sites running MySQL 5.

_________________
Rey Gigataras - Joomlatools Team Member
http://www.joomlatools.eu <-- Joomla extensions that just work
http://path.to/rey.gigataras <-- About Me
Online Community Manager, Support Engineer, Web Developer, Event Manager, Sports Coach

Oh, that makes so much sense now. Thank you Rey! I am having the same problem on my local machine and am running MySql 5 there too, so that totally makes sense. Thank you again! I was so worried that I would have to go backwards with this site because I installed a wrong component or something and was thinking I was going to lose a lot of work, so phew!

_________________
Giving shape to your concept
http://www.intuitivedesigns.net

Ok, I think I spoke too soon. My host won't turn it off because I'm in a shared environment, so I tried the method outlined in this thread:
http://forum.joomla.org/index.php/topic,30542.0.html

I'm still having the same issues.

_________________
Giving shape to your concept
http://www.intuitivedesigns.net

Suggest you utilize this proposed solution for users on MySQL 5 with strict mode on:
http://forum.joomla.org/index.php/topic,47032.0.html

_________________
Rey Gigataras - Joomlatools Team Member
http://www.joomlatools.eu <-- Joomla extensions that just work
http://path.to/rey.gigataras <-- About Me
Online Community Manager, Support Engineer, Web Developer, Event Manager, Sports Coach

Bummer, I still can't get it working after trying this either. My host wrote back and said that the version of MySql on this servers is actually 4.0.16, not 5. I have xampp on my local machine and they say that it's MySql version 5, but not in strict mode, so now I'm really getting worried.

_________________
Giving shape to your concept
http://www.intuitivedesigns.net

Hallo,

I have the same problem here on my localhost. Did a repair of my DB but there wasn't anything to repair.



System-Info:

Check if the ID field is auto-increment

Ivo,

I don't know how I can thank you enough. That was it!

I wonder how that got lost? I'm going to go through my sql backups to see if I can find what happened.

Thank you again!!!

_________________
Giving shape to your concept
http://www.intuitivedesigns.net

No problem, it is strange as this is the third such issue, can you tell me what was the initial version you installed?

Ivo,

I think this happened when I exported the database from my web host to my localhost because I had to export the data as a lower version of MySql because it wouldn't import before. Incidentally, I cannot make the id fields on my local host auto_increment because I get this error:
#1067 - Invalid default value for 'id'

After looking in Google, it looks like this is a common issue, so I guess it's all related. Here are my configurations for both my hosting account and my locahost.

Web Host:


My Localhost:


Thanks again!

_________________
Giving shape to your concept
http://www.intuitivedesigns.net

Same as previous from MySQL 5 to 4

Oh yeah, sorry, I got it backwards. I had to export for a lower version from my localhost to my web host. That is, from 5 to 4, yes.

_________________
Giving shape to your concept
http://www.intuitivedesigns.net