Hi there,

I have done some modifications on your custom.css and it should works fine now. Please give it a check and see how it goes

Still the same

not sure if this could help or not, but i'm on google chrome on the latest version of windows 10

Hi there,

I have made some modifications on your site and maybe you need to clear your chrome browser cache first and see how it goes.

When i go to edit the post, i get this:

Hi there,

It seems that your new stream items cant be edited as it might be because of the acph user you talk about as when i try to edit your previous stream item as you can see here https://screencast.com/t/DNKw26WxEP9, it shown correctly.

By the way, based on your previous ticket, how did you solve your issues? As this might have some problems to recognize your id and unable to edit those stream.

Maybe you can provide us with you database for further check on this issues.
Please advice.

I uploaded my database credentials in the the json ticket

Regarding this issue, I've checked from your database, it seems like these following 2 Easysocial stream table id not set to "auto increment" for some reason so when you create a new stream item on your site, it will stored it as id 0 which caused this issue
- #__social_stream
- #__social_stream_item

May i know what you did previously from your database? Did you migrate your database data from old site to new site recently?

By the way, I think you already backup your database data, for now can I have the permission to delete all of your existing stream which id is 0 from your database? Because it caused the issue when I would like to set above 2 stream table id to primary key and set it to auto increment.

I try to do nightly backups of all my site files and database. The database i restored was the backup from before i had all these issues. I have made a current backup of the database just now so if you wish to edit anything, go ahead, (stream)

I already help you updated all the existing Easysocial table id columns auto increment and delete those id 0 data from your database, can you give it a check again is it everything work fine now?

By the way, I also noticed your other table also missing those primary key and the auto increment , I think your database all the table get messed up.

i had seen from the front end that everything is working fine. However, my main menu has disappeared from the desktop. The mobile version is working fine, but the desktop version is not. When i go into admin panel, i have 80 billion duplicates of each menu item. I believe this is also tied into the same problem.

Is my whole database screwed up? I have no idea how to fix anything like that

However, my main menu has disappeared from the desktop. The mobile version is working fine, but the desktop version is not. When i go into admin panel, i have 80 billion duplicates of each menu item. I believe this is also tied into the same problem.

Hm, I didn't touch anything from your site related those menu item.
I suspect when you restore your database to previously, it caused this duplicated menu item.
Just now i also noticed your plugin manager page also show duplicated item.

Is my whole database screwed up? I have no idea how to fix anything like that

Yes, based on what my observation, you have to check each existing table from your database manually add the primary key and the auto increment on id columns if the table got id column exist, you can refer on my attached screenshot below.

every single table has to look like that?

Yes, based on what my observation, you have to check each existing table from your database manually add the primary key and the auto increment on id columns if the table got id column exist, you can refer on my attached screenshot below.

If i have more than one as a primary, do i need to change the other one to a non primary?

i guess one other question i would have is this:

When i am backing up my databases, what options should i select so that i can make sure I am downloading the database correctly so that if I ever have to restore the database, i don't have to go through this again?

Arlex, can you please help me figure out my database for the main menu for the website. I have tried to edit all of the settings for the id fields on the database, but for some reason, ap3_menu and ap3_users will not change for me. I beg of you to please do this for me as my website is currently down until i get the menu thing fixed and i cant get any new registered users until the users thing is fixed.

This is the error that i pull up when trying to edit my menu from the admin panel:

1062 Duplicate entry '0' for key 'PRIMARY' SQL=INSERT INTO `#__menu` (`parent_id`,`level`,`lft`,`rgt`,`alias`,`id`,`menutype`,`title`,`note`,`path`,`link`,`type`,`published`,`component_id`,`browserNav`,`access`,`img`,`template_style_id`,`params`,`home`,`language`) VALUES ('1','1','345','346','home12245','0','primarymenu','Home','','home12245','index.php?option=com_easysocial&view=dashboard&type=everyone','component','1','10236','0','1',' ','0','{\"menu-anchor_title\":\"\",\"menu-anchor_css\":\"\",\"menu_image\":\"\",\"menu_text\":1,\"menu_show\":1,\"page_title\":\"\",\"show_page_heading\":\"\",\"page_heading\":\"\",\"pageclass_sfx\":\"\",\"menu-meta_description\":\"\",\"menu-meta_keywords\":\"\",\"robots\":\"\",\"secure\":0,\"dropdown_position\":\"right\",\"showmenutitle\":\"1\",\"icon\":\"\",\"class\":\"\",\"enable_page_title\":\"0\",\"page_title_alt\":\"\",\"page_subtitle\":\"\",\"page_title_bg_color\":\"\",\"page_title_bg_image\":\"\"}','0','*')

uninstalling or installing extensions just loads a white screen. I have a feeling i have totally screwed up my webiste

every single table has to look like that?

Yes, except Easysocial table #__social_xxx .

If i have more than one as a primary, do i need to change the other one to a non primary?

No need, as long as that is id columns, you should assign it to primary key and set this id to auto increment.
So when that is new record come in, it will automatically generate another new id on the record and stored in your database.

i guess one other question i would have is this:

When i am backing up my databases, what options should i select so that i can make sure I am downloading the database correctly so that if I ever have to restore the database, i don't have to go through this again?

May i know how to you backup on your database previously?

Normally how i backup is export the database with all the table to sql dump file, you can check my screenshot here : http://take.ms/s9bfy so it will export all the table and data into .sql dump file.

Arlex, can you please help me figure out my database for the main menu for the website. I have tried to edit all of the settings for the id fields on the database, but for some reason, ap3_menu and ap3_users will not change for me. I beg of you to please do this for me as my website is currently down until i get the menu thing fixed and i cant get any new registered users until the users thing is fixed.

Please understand this is actually beyond of our support scope, because this is not our extension messed up your current database table structure and those showing duplicate menu item/plugin/module from backend.

Hm, may i know what you did just now then make your site down?

This is the error that i pull up when trying to edit my menu from the admin panel:

1062 Duplicate entry '0' for key 'PRIMARY' SQL=INSERT INTO `#__menu` (`parent_id`,`level`,`lft`,`rgt`,`alias`,`id`,`menutype`,`title`,`note`,`path`,`link`,`type`,`published`,`component_id`,`browserNav`,`access`,`img`,`template_style_id`,`params`,`home`,`language`) VALUES ('1','1','345','346','home12245','0','primarymenu','Home','','home12245','index.php?option=com_easysocial&view=dashboard&type=everyone','component','1','10236','0','1',' ','0','{\"menu-anchor_title\":\"\",\"menu-anchor_css\":\"\",\"menu_image\":\"\",\"menu_text\":1,\"menu_show\":1,\"page_title\":\"\",\"show_page_heading\":\"\",\"page_heading\":\"\",\"pageclass_sfx\":\"\",\"menu-meta_description\":\"\",\"menu-meta_keywords\":\"\",\"robots\":\"\",\"secure\":0,\"dropdown_position\":\"right\",\"showmenutitle\":\"1\",\"icon\":\"\",\"class\":\"\",\"enable_page_title\":\"0\",\"page_title_alt\":\"\",\"page_subtitle\":\"\",\"page_title_bg_color\":\"\",\"page_title_bg_image\":\"\"}','0','*')

Let me explain to you, this whole issue is started from your database table structure messed up then causing a lot of your current issue, because a lot of duplicate id 0 data from your existing table.

uninstalling or installing extensions just loads a white screen. I have a feeling i have totally screwed up my webiste

Hm, what extension you uninstall and reinstall?
Please give me a time to help you check why your site suddenly down and can you explain to me what you did just now on your site, so I can think which part causing this issue and see if I can help you figure out this.

May i know how to you backup on your database previously?

I usually do it the same way you just showed me.

Please understand this is actually beyond of our support scope, because this is not our extension messed up your current database table structure and those showing duplicate menu item/plugin/module from backend.

Hm, may i know what you did just now then make your site down?

I tried to edit my menu, but the whole menu got deleted and as a result i had no default page set in my menu. I tried to create a new menu, and then i get a database error informing me something about a duplicate when i try to create a new menu item. After that all i can get is a 404 error, 'component not found'. I have since just taken the front end offline for users but even that just gives me redirects.

This is the error that i pull up when trying to edit my menu from the admin panel:

1062 Duplicate entry '0' for key 'PRIMARY' SQL=INSERT INTO `#__menu` (`parent_id`,`level`,`lft`,`rgt`,`alias`,`id`,`menutype`,`title`,`note`,`path`,`link`,`type`,`published`,`component_id`,`browserNav`,`access`,`img`,`template_style_id`,`params`,`home`,`language`) VALUES ('1','1','345','346','home12245','0','primarymenu','Home','','home12245','index.php?option=com_easysocial&view=dashboard&type=everyone','component','1','10236','0','1',' ','0','{\"menu-anchor_title\":\"\",\"menu-anchor_css\":\"\",\"menu_image\":\"\",\"menu_text\":1,\"menu_show\":1,\"page_title\":\"\",\"show_page_heading\":\"\",\"page_heading\":\"\",\"pageclass_sfx\":\"\",\"menu-meta_description\":\"\",\"menu-meta_keywords\":\"\",\"robots\":\"\",\"secure\":0,\"dropdown_position\":\"right\",\"showmenutitle\":\"1\",\"icon\":\"\",\"class\":\"\",\"enable_page_title\":\"0\",\"page_title_alt\":\"\",\"page_subtitle\":\"\",\"page_title_bg_color\":\"\",\"page_title_bg_image\":\"\"}','0','*')

Let me explain to you, this whole issue is started from your database table structure messed up then causing a lot of your current issue, because a lot of duplicate id 0 data from your existing table.

Would it then be a bad idea to try and do a backup of my database? I was thinking of just getting rid of everything and rebuilding the website from scratch, but it sounds like my database would just transfer the problems over to the new site?

uninstalling or installing extensions just loads a white screen. I have a feeling i have totally screwed up my website

Hm, what extension you uninstall and reinstall?

I tried to actually install the jgive component. That was when I discovered the issue. Then i found that it actually DID install the component and then when i tried to uninstall it, it did the same thing. The installation and uninstallations work, they just result in a blank white screen.

Please give me a time to help you check why your site suddenly down and can you explain to me what you did just now on your site, so I can think which part causing this issue and see if I can help you figure out this.

Anytime is good for me, and thank you.

It seems like your homepage hitting this following error :

404 Component not found.

I suspect that is because your 'new primary menu' gone through from your backend, can you try add new menu item from backend and see how it goes?

I already help you clear the id 0 record from your database #__menu table, you shouldn't hitting that sql error again.

I do have the homepage showing now. Being able to edit the menu allowed me to set anew default

Thanks for getting back to us you can able to edit your menu now.

If you have another new issue, I would suggest you start a new thread so it will help us easier to manage your issue.