What are the chances?

[bigfanboy]

I am having serious issues with an upgrade I did from 1.3.3 to 1.4.10. I have been getting some advice but no luck getting it work as of yet.

I have done a clean install to a new subdomain and this new install seems to work fine. I can create users and groups and upload tons of pics. (which was the first issue I ran into, and upload of any kind and way used would hose the whole site, and not upload the pics to boot).

Anyway I know the issue is not with 1.4.10 clean, I have run the upgrade from 1.3.3 to 1.4.10 so the DB might be good. What are the odds I can drop a fresh blank 1.4.10 on disk, delete the install.php change the config.inc.php file so it matches my DB settings, ove the albums dir over and have it work right?

Thoughts?

Big

[Joachim Müller]

Upgrade as suggested in the docs, then post what errors you have with the upgrade. Let's then look into those issues together.

[bigfanboy]

I had no errors on the upgrade but I cannot ceate new users. Well I can but then they cannot log in.

http://todd.my-familypics.com.

Also I cannot get to the categories admin menu, I always get a 400

Big

[Joachim Müller]

What's a "400"? Post the exact error message you get when accessing http://todd.my-familypics.com/catmgr.php

I tried to register as a new user on your page, which led to the error message

While executing query "INSERT INTO cpg133_users (user_regdate, user_active, user_actkey, user_name, user_password, user_email, user_profile1, user_profile2, user_profile3, user_profile4, user_profile5, user_profile6) VALUES (NOW(), 'NO', '81e809742ac69e48b3bb63a94362f9aa', 'tester', '1234', 'mail@gaugau.de', '', '', '', '', '', '')" on 0

mySQL error: Duplicate entry '0' for key 1

, which indicates that the user_id column is not set to auto-increment. Use phpMyAdmin and set user_id to auto-increment.

[bigfanboy]

OK I set the uder_id in the users table to autoincrement and now new users can be created.

But I still get the HTML server error 400 when I try to go to catmgr

this is the text of the error that come back from the server

INTERNAL SERVER ERROR

An internal server error has occured!
Please try again later.

[bigfanboy]

What other fields should be autoincrement but the way because none are.

[Nibbler]

Check sql/schema.sql. That 400 error is probably a security measure by your webhost. Try renaming the file.

[bigfanboy]

Check sql/schema.sql. That 400 error is probably a security measure by your webhost. Try renaming the file.

Can you give me more info into what you are suggesting?

I looked at schemas.sql to tell which tables are autoincrement, but none show that setting.

Then the question is try renaming what file? sql/schema.sql?

[bigfanboy]

I was wrong about the auto_increment I was looking for autoincrment no _ I will make the needed changes.

[bigfanboy]

OK I added auto_increment to all the tables that needed it. For some reason only a few had this setting. I can now get to the categories mgr page.

My next test will be to upload a new pic to the site. I will use the trouble shooting link I was given in a previous topic, when my challenges first started.

If you want to call this one solved or move it to the "can't upload" Cat is up to you.

if I see it as solved and still have upload issues I will open a new topic.

Thanks For you help so far

[bigfanboy]

I followed all the directions, now when I try and upload a file I get this error

No file was uploaded !

If you have really selected a file to upload, check that the server allows file uploads...

File: /homepages/31/d186234617/htdocs/my-familypics.com/todd.my-familypics.com/db_input.php - Line: 311

[Joachim Müller]

if I see it as solved and still have upload issues I will open a new topic.

Do so. Read the upload troubleshooting section of the docs and do exactly as suggested there. Closing, locking.