Quick Question

[myimghost]

I upgraded from 4 to the latest version 5.2b and now I get mysql errors when trying to edit settings and the random image option doesn't work.

Any ides what can cause this or how to fix it?

I assume I need to upgrade the mysql database some how?

Thanks,

[kashwak]

if you was running the old version 4.xx then you should have upgraded using the files from the project page to upgrade to 5.0.0 and then upgrade to 5.0.1.

from there you can upgrade to 5.0.2 or 5.0.2b

since you have upgraded strait from 4.xx to 5.0.2b i do not know if it can be fixed.

Let me talk to Josh and one of us will get back to you.

[Josh D.]

You're more than likely just missing some of the MySQL data, I'll go through the different versions and see if I can come up with a list of the data you may need.

[myimghost]

You're more than likely just missing some of the MySQL data, I'll go through the different versions and see if I can come up with a list of the data you may need.

Thanks, yep I think I just need to know the tables to add.

Sorry I tried to find how to update but I didn't know of the project page

[Josh D.]

Here's a list of differences between v4 and v5:

mmh_file_logs
Field user_agent differs between databases for parameter 'Type'. v4 (localhost) has 'tinytext' and v5 (localhost) has 'varchar(255)'.
Field original_filename differs between databases for parameter 'Type'. v4 (localhost) has 'tinytext' and v5 (localhost) has 'varchar(255)'.
v4 (localhost) is missing field: upload_type
v4 (localhost) is missing field: bandwidth
v4 (localhost) is missing field: image_views

mmh_file_ratings
v4 (localhost) is missing field: is_private
v4 (localhost) is missing field: gallery_id

mmh_file_storage
v4 (localhost) is missing field: viewer_clicks

mmh_gallery_albums
v4 (localhost) is missing field: password
v4 (localhost) is missing field: is_private

mmh_robot_info
Field preg_match differs between databases for parameter 'Type'. v4 (localhost) has 'tinytext' and v5 (localhost) has 'varchar(255)'.
Field robot_name differs between databases for parameter 'Type'. v4 (localhost) has 'tinytext' and v5 (localhost) has 'varchar(100)'.

mmh_robot_logs
Field user_agent differs between databases for parameter 'Type'. v4 (localhost) has 'tinytext' and v5 (localhost) has 'varchar(255)'.

mmh_user_info
Field email_address differs between databases for parameter 'Type'. v4 (localhost) has 'tinytext' and v5 (localhost) has 'varchar(255)'.
Field user_group differs between databases for parameter 'Default'. v4 (localhost) has '' and v5 (localhost) has 'normal_user'.
v4 (localhost) is missing field: upload_type

mmh_user_sessions
Field user_agent differs between databases for parameter 'Type'. v4 (localhost) has 'tinytext' and v5 (localhost) has 'varchar(255)'.

mmh_user_passwords
v4 (localhost) is missing table: mmh_user_passwords

[myimghost]

Here's a list of differences between v4 and v5:

mmh_file_logs
Field user_agent differs between databases for parameter 'Type'. v4 (localhost) has 'tinytext' and v5 (localhost) has 'varchar(255)'.
Field original_filename differs between databases for parameter 'Type'. v4 (localhost) has 'tinytext' and v5 (localhost) has 'varchar(255)'.
v4 (localhost) is missing field: upload_type
v4 (localhost) is missing field: bandwidth
v4 (localhost) is missing field: image_views

mmh_file_ratings
v4 (localhost) is missing field: is_private
v4 (localhost) is missing field: gallery_id

mmh_file_storage
v4 (localhost) is missing field: viewer_clicks

mmh_gallery_albums
v4 (localhost) is missing field: password
v4 (localhost) is missing field: is_private

mmh_robot_info
Field preg_match differs between databases for parameter 'Type'. v4 (localhost) has 'tinytext' and v5 (localhost) has 'varchar(255)'.
Field robot_name differs between databases for parameter 'Type'. v4 (localhost) has 'tinytext' and v5 (localhost) has 'varchar(100)'.

mmh_robot_logs
Field user_agent differs between databases for parameter 'Type'. v4 (localhost) has 'tinytext' and v5 (localhost) has 'varchar(255)'.

mmh_user_info
Field email_address differs between databases for parameter 'Type'. v4 (localhost) has 'tinytext' and v5 (localhost) has 'varchar(255)'.
Field user_group differs between databases for parameter 'Default'. v4 (localhost) has '' and v5 (localhost) has 'normal_user'.
v4 (localhost) is missing field: upload_type

mmh_user_sessions
Field user_agent differs between databases for parameter 'Type'. v4 (localhost) has 'tinytext' and v5 (localhost) has 'varchar(255)'.

mmh_user_passwords
v4 (localhost) is missing table: mmh_user_passwords

Can I just pay you like $25 Paypal to do this for me? lol Sorry

[myimghost]

O.K. I added the missing fields as int fields with the default settings and added the new table mmh_user_passwords with the field password.

Is this correct?

[myimghost]

Wow I just realized nothing works anymore before I tried to add the mysql changes. So it's been down for over a week.

Seriously can I have someone fix this?

[kashwak]

ok first thing do you have a back up from before you tried to update?

if you do then replace all files with the backup.

if you do not then then you can try this.

reset/undo everything you have done to the sql.

go to the project page and download the version you had.

upload it overwriting everything but your config.php file

then do the upgrades once you get to v5.0.2 all you have to do is overwrite everything but your config.php and you are good to go.

i hope this helps.

[myimghost]

ok first thing do you have a back up from before you tried to update?

if you do then replace all files with the backup.

if you do not then then you can try this.

reset/undo everything you have done to the sql.

go to the project page and download the version you had.

upload it overwriting everything but your config.php file

then do the upgrades once you get to v5.0.2 all you have to do is overwrite everything but your config.php and you are good to go.

i hope this helps.

I feel like such an idiot. I don't have a back up and now that I changed the mysql it won't work with the old version I don't think.

I will have to try, you are sure there is no way I can just send you the cpanel ftp details and have you upgrade it for me?