DB error after user joins / No photo upload?

Hi guys. Yesterday my server went down and today I noticed that all of the new members since then have no profile photo. I decided to make a test profile and noticed that the join form errors out after the join form processes. After digging a little further I came across this:

Database error in XXXXX

Query:

INSERT INTO  `sys_albums` SET `sys_albums`.`Caption` = 'steveo79\'s photos', `sys_albums`.`Uri` = 'steveo79-s-photos', `sys_albums`.`Location` = 'Undefined', `sys_albums`.`AllowAlbumView` = '3', `sys_albums`.`Type` = 'bx_photos', `sys_albums`.`Owner` = '86899', `sys_albums`.`Status` = 'active', `sys_albums`.`Date` = '1391442919', `sys_albums`.`LastObjId` = '0' 

Mysql error: Duplicate entry '63433' for key 'PRIMARY'

Found error in the file '/home/xxxxxx/public_html/inc/classes/BxDolAlbums.php' at line 100.
Called 'res' function with erroneous argument #0

Its happening to all new members. Please HELP.

INSERT INTO  `sys_albums` SET `sys_albums`.`Caption` = 'steveo79\'s photos', `sys_albums`.`Uri` = 'steveo79-s-photos', `sys_albums`.`Location` = 'Undefined', `sys_albums`.`AllowAlbumView` = '3', `sys_albums`.`Type` = 'bx_photos', `sys_albums`.`Owner` = '86899', `sys_albums`.`Status` = 'active', `sys_albums`.`Date` = '1391442919', `sys_albums`.`LastObjId` = '0' 

Makes no sense. There is no 63433 that it's complaining about in the query. And Key PRIMARY should be the ID field which should be auto incrementing and keeping a index to prevent that from happening.

My only conclusion is the table is damaged. Either the id field is no longer set to auto increment or the database index is damaged.

Check the table sys_albums and make sure the ID field is still set to auto_increment and that it's index is still there. Also try doing a repair of the database.

Deano, The Auto Increment is set and I went ahead and repaired the DB but the issue still persists. I'm using the profile photo option instead of the avatar option. I have noticed that when I click on some of the user profile photos it links to other user profiles??? 

Are you sure thats the full query?

The report is Way too long so here is a snippet:

Database error in 

Query:

SELECT `sys_albums`.`ID` FROM `sys_albums` WHERE `sys_albums`.`Uri` = 'sexybrunette6969-s-photos' AND `sys_albums`.`Owner` = '70940' AND `sys_albums`.`Type` = 'bx_photos' LIMIT 1

Mysql error: Table './xxxxxxx_peach5/sys_albums' is marked as crashed and should be repaired

Found error in the file '/home/xxxxxxx/public_html/inc/classes/BxDolAlbums.php' at line 320.

Called 'getRow' function with erroneous argument #0.

Debug backtrace:

Array

(

    [1] => Array

        (

            [file] => /home/xxxxxxx/public_html/inc/classes/BxDolDb.php

            [line] => 237

            [function] => error

            [class] => BxDolDb

            [object] => BxDolDb Object

                (

                    [error_checking] => 1

                    [error_message] => Table './xxxxxxx_peach5/sys_albums' is marked as crashed and should be repaired

                    [host] => localhost

                    [port] => 

                    [socket] => 

                    [dbname] => xxxxxxx_peach5

                    [user] => *****

                    [password] => *****

                    [link] => Resource id #24

                    [current_res] => 

                    [current_arr_type] => 1

                    [oParams] => BxDolParams Object

                        (

                            [_oDb] => BxDolDb Object

 *RECURSION*

                            [_oCache] => BxDolCacheFile Object

                                (

                                    [sPath] => /home/xxxxxxx/public_html/cache/

                                )

                            [_sCacheFile] => sys_options_ed1792a6d2968f0f950a8d589a642ab3.php

                            [_aParams] => [truncated]

                        )

                    [oDbCacheObject] => BxDolCacheFile Object

                        (

                            [sPath] => /home/xxxxxxx/public_html/cache/

                        )

                )

            [type] => ->

            [args] => Array

                (

                    [0] => Database query error

                    [1] => 

                    [2] => SELECT `sys_albums`.`ID` FROM `sys_albums` WHERE `sys_albums`.`Uri` = 'sexybrunette6969-s-photos' AND `sys_albums`.`Owner` = '70940' AND `sys_albums`.`Type` = 'bx_photos' LIMIT 1

                )

        )

    [2] => Array

        (

            [file] => /home/xxxxxxx/public_html/inc/classes/BxDolDb.php

            [line] => 101

            [function] => res

            [class] => BxDolDb

            [object] => BxDolDb Object

                (

                    [error_checking] => 1

                    [error_message] => Table './xxxxxxx_peach5/sys_albums' is marked as crashed and should be repaired

                    [host] => localhost

                    [port] => 

                    [socket] => 

                    [dbname] => xxxxxxx_peach5

                    [user] => *****

                    [password] => *****

                    [link] => Resource id #24

                    [current_res] => 

                    [current_arr_type] => 1

                    [oParams] => BxDolParams Object

                        (

                            [_oDb] => BxDolDb Object

 *RECURSION*

                            [_oCache] => BxDolCacheFile Object

                                (

                                    [sPath] => /home/xxxxxxx/public_html/cache/

                                )

                            [_sCacheFile] => sys_options_ed1792a6d2968f0f950a8d589a642ab3.php

                            [_aParams] => [truncated]

                        )

                    [oDbCacheObject] => BxDolCacheFile Object

                        (

                            [sPath] => /home/xxxxxxx/public_html/cache/

                        )

                )

            [type] => ->

            [args] => Array

                (

                    [0] => SELECT `sys_albums`.`ID` FROM `sys_albums` WHERE `sys_albums`.`Uri` = 'sexybrunette6969-s-photos' AND `sys_albums`.`Owner` = '70940' AND `sys_albums`.`Type` = 'bx_photos' LIMIT 1

                )

        )

    [3] => Array

        (

            [file] => /home/xxxxxxx/public_html/inc/classes/BxDolAlbums.php

            [line] => 320

            [function] => getRow

            [class] => BxDolDb

            [object] => BxDolDb Object

                (

                    [error_checking] => 1

                    [error_message] => Table './xxxxxxx_peach5/sys_albums' is marked as crashed and should be repaired

                    [host] => localhost

                    [port] => 

                    [socket] => 

                    [dbname] => xxxxxxx_peach5

                    [user] => *****

                    [password] => *****

                    [link] => Resource id #24

                    [current_res] => 

                    [current_arr_type] => 1

                    [oParams] => BxDolParams Object

                        (

                            [_oDb] => BxDolDb Object

 *RECURSION*

                            [_oCache] => BxDolCacheFile Object

                                (

                                    [sPath] => /home/xxxxxxx/public_html/cache/

                                )

                            [_sCacheFile] => sys_options_ed1792a6d2968f0f950a8d589a642ab3.php

                            [_aParams] => [truncated]

                        )

                    [oDbCacheObject] => BxDolCacheFile Object

                        (

                            [sPath] => /home/xxxxxxx/public_html/cache/

                        )

                )

            [type] => ->

            [args] => Array

                (

                    [0] => SELECT `sys_albums`.`ID` FROM `sys_albums` WHERE `sys_albums`.`Uri` = 'sexybrunette6969-s-photos' AND `sys_albums`.`Owner` = '70940' AND `sys_albums`.`Type` = 'bx_photos' LIMIT 1

                )

        )

Perhaps you missed this part in the error report.

Mysql error: Table './xxxxxxx_peach5/sys_albums' is marked as crashed and should be repaired

That most likely is the problem.

Perhaps i should have been more clear when i said repair database. My fault. I meant repair that table. The sys_albums table. That error was not in your first post because you did not provide it. But it is in your other post containing the full report.

So the table is indeed damaged and must be repaired.

For future reference. All that is needed is the portion of the report that is above the words Debug backtrace:

This is why you guys are the Pros. I did the table repair and a member just joined with a working profile + Photo. 

Thanks for the quick replies Deano.