Try to fix a CMSMS website througt database

[Marthap]

Hello,

I have been asked to try to publish a broken website made with CMSMS version 1.11.4 again. The website is made via Installatron.
It is not possible to log in via admin.
I have download the database and imported it in Xampp and saw that the prefix of the tables of the database are not all the same.
CMS_ is up to and including cms_permissions_seq the rest of the prefixes are different pzsu_
My question is shouldn't the prefix be the same?
And who can help me with this problem?
I will notice that I am very experienced with CMS Joomla.
Thank you in advance!
greetz Martha
www.kolham.nu

[Dr.CSS]

Since you have the DB for this site you should be able to change the admin password to get into the backend if that is what is stopping you from getting in there...

Yes all prefixes should be the same, I would try changing all the prefixes to cms_...

[Marthap]

Thank you dr CSS,
Yes that was what I wanted to do, to change the password and usersname. But I am not shore if I change the prefixes to one name, that this can give more problems. But I shall try it first in Xampp.

[Rolf]

https://cmscanbesimple.org/blog/cms-mad ... d-recovery

[Marthap]

Thanks Rolf, I already found that solution.

First I have an other problem.
There are several same tables with both prefixes. (cms_ and pzsu_)

Can I delete this tables and leave the tables with cms_?

pzsu_events_sec
pzsu_groups_perm_seq
pzsu_module_news
pzsu_module_news_categories
pzsu_module_news_categories_seq
pzsu_module_news_fielddefs
pzsu_module_news_fieldvals
pzsu_module_news_seq

[DIGI3]

Whatever is defined for the database prefix in your config.php will be the one you're using (if nothing is defined, it will be cms), the others can most likely be removed. Back up first, of course.

[Marthap]

In config.php is _cms defined. But I checked the tables and the content of the same tables are not the same. Should I transport this tables to the tables with _cms?

[DIGI3]

No idea. You'd have to consult with whoever did that as to why there's multiple table prefixes. I would guess they either had two installs sharing the same database, or they did some weird method of backing up each table before making changes.

[calguy1000]

CMSMS allows co-existing with other applications in the same mysql database. That's what the prefix is for. You can also install multiple CMSMS installs using the same mysql database (but separate filesystem paths)

So. Generally speaking you need to know your system(s) before you go dropping or renaming tables.

Note: there have been problems in the past with some third party modules not using the prefix. But I don't know your system info OR which versions of which modules had the problem.

If you are absolutely certain that there is only one application using that database, AND that is CMSMS and you know that the prefix then you MAY want to either drop or rename the tables.

IF your verified system is using a prefix like 'cms_' and you have tables like 'foo_*' in the database who's suffixes don't ALSO exist in the cms_ prefix. then it MAY be an idea to rename these tables. But it would take careful analysis of the source code.

[Marthap]

Thankyou callguy1000
That's why I test this problem in the Xampp database. I know how te work with database but not with CMSMS.
Maybe it's better to rebuild the website. Hopefully I find the texts from the website in the database.

[Marthap]

We can't contact the one who build the website, He does not respond to our messages.

Is there a change that I can get the content somewhere from the files or database of the website?

I am also unable to publish the website via xampp. I think the version is too old. If there is someone who can help to publish the website via xampp, please do response.

[Dr.CSS]

Are you unable to see the site at all..?

The content is stored in the database, have you tried https://archive.org/web/
I've used it before to reconstruct sites...