Upgraded Host Servers - Now Site Is Down

Gigs & Jobs
1

our host upgraded their servers and following the upgrade our site is down. From what I can tell its a compatibility issue. having trouble finding an answer. Any ideas?

So far Ive attempted and come to the conclusion

  • you can’t spin up a newer version of concrete5 and just link the old database to it. Therefore, in order to get the site to work, I either have to install a new version of concrete5, extract the data from the database, somehow import the old data into the new version. (This is just a rough guess based on my research.)
    Or,
    I can download the site, (public_html/concrete directory) and then see if I can find the sql issues, upload the changes and then try to connect to the website. Then repeat until I find the error?

help please thank you

2 Likes
2

It’s more than likely the host changed the PHP version on the server.

If you want me to look into it email me
hello@tm-designs.co.uk

1 Like
3

Thank you, I do appreciate it.

1 Like
4

Hello @mdm502

I would be glad to assist you to fix the issue. Please Feel free to contact me for further discussion using the provided information.

E- alanjones(dot)tis(at)gmail(dot)com
Skype - live:.cid.6a62b7b34d1aa390

5

Hello,
Its due to php version on server and old concrete5 version. We may fix it by changing php version from the Cpnael(server) or to the version upgrade of ConcreteCMS to the latest that support PHP8+.

Thanks,
Shivank Agrawal

1 Like
6

Hello,
Greetings!

I’ve reviewed your requirements and I’m prepared to assist you.
Feel free to reach out:

Email: jack(at)technogiq(dot)com
Skype: live:.cid.a0f06a69cf1c6478

Looking forward to hearing from you.

Regards,
Jack Smith

7

Just to add like you everyone face such issues, when you are doing version upgrade for quite older version. So I have done such migrations successfully and interested helping you on same.

Please connect further, If still looking

eMail: deepvyas71@gmail.com

Regards
Deep

8

Hello @mdm502
Greetings!!

I am delighted to assist you in resolving the issue. Please don’t hesitate to reach out to me using the contact information provided for any further discussion.

Email – ianradnor088(at)gmail(dot)com
Skype – live:ianradnor088

Regards
Ian

9

@mdm502 I found the issue and the site is now back up and running

The host had updated to a new version of mySQL. Part of the problem appears to be that the word groups is reserved in the latest versions of MYSQL and needs to be escaped using `.

The problem query worked when I changed it to:

from Groups

to

from `Groups`

you also need to escape them for “into”

so in file
concrete5.6.3.3/concrete/core/models/groups.php it need to look like this

	public static function getByName($gName) {
			$db = Loader::db();
			$row = $db->getRow("select * from `Groups` where gName = ?", array($gName));
			if (isset($row['gID'])) {
				$g = new Group;
				$g->setPropertiesFromArray($row);
				return $g;
			}
		}

and

	public static function add($gName, $gDescription, $gID=null) {
			$db = Loader::db();
			$v = array($gID, $gName, $gDescription);
			$r = $db->prepare("insert into `Groups` (gID, gName, gDescription) values (?, ?, ?)");
			$res = $db->Execute($r, $v);
			
			if ($res) {
				$ng = Group::getByID($gID ? $gID : $db->Insert_ID());
				Events::fire('on_group_add', $ng);
				return $ng;
			}
		}

there are a few more in the file.

10

Groups is one of the fixes in 5.6.4 in legacy GitHub.