Educon - Upgraded To Joomla 4 - 1064 Error - Question | JoomShaper
Black Friday sale is live with flat 50% OFF. Sale ends soon! Grab your deal now!

Educon - Upgraded To Joomla 4 - 1064 Error

R

Rabah

SP Page Builder 3 years ago

Good morning, We recently upgraded to a test server Educon template to joomla 4. Faced a few issues that were resolved but we have a few issues still apprent

The hompage slider is not loading: https://dev2.pniph.org/index.php/en/ Clicking home page to edit, get error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY lft ASC' at line 3

The following pages, also when we try to edit gets the same error: ID 35 ID 39 ID 53 ID 54

Some images are not automatically takeing the whole width automticllay https://dev2.pniph.org/index.php/en/about/stakeholders-and-partners

https://dev2.pniph.org/index.php/en/component/content/article/mammography-screening-data-review?catid=92&Itemid=563

Current PHP version, 8.0 | Current Joomla version after upgrade: 4.1.5 Latest packages installed for Educon template: com_sppagebuilder_pro_v4.0.3 | educon_template Version 4.0.1 | com_splms_fullpackage_v4.0.7 | com_speasyimagegallery_fullpackage_v2.0.2

Thank you for your support!

0
22 Answers
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #81728

Hi there,

Thanks for contacting us. Sorry for the inconvenience. The Educon template is overridden the extension of LMS. You should wait for the template update.

-Thanks

0
R
Rabah
Accepted Answer
3 years ago #81735

Thank you for your reply Toufiq... I was working on updating site and nearly got there as I thought it was ready for latest updates..etc.

Is there an timeframe/estimation to the template update?

Thank you again,

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #81737

I will try to manage it soon with PHP 8 compatible. Thanks

0
R
Rabah
Accepted Answer
3 years ago #81871

Thank you Toufiq appreciate it! Noticed on some of the posts that SP Simple Portfolio could be related issue to the problem. When I disabled it the home page slider now works but trying to edit it and other pages results in error 1064.

Hopefully, we will get a new update with fix.. thank you again!

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #81901

I just checked two pages and it works fine.

https://prnt.sc/s6BMLVGB7YCF

0
R
Rabah
Accepted Answer
3 years ago #81904

Thank you for your reply! Some of the pages are working and others aren't. For example, these are the ones im talking about

https://dev2.pniph.org/index.php/en/edit/35 https://dev2.pniph.org/index.php/en/edit/39 https://dev2.pniph.org/index.php/en/edit/53

https://dev2.pniph.org/index.php/en/component/tags/tag/rta

Screen shot from one them them https://prnt.sc/RHMz_hEuG996

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #81907

Got it. This issue will fix it next update of Template. Cause, The educon template has override addon and which is need to make compatible with the Page Builder 4 & PHP 8. Thanks

0
R
Rabah
Accepted Answer
3 years ago #81915

thank you .. looking forward to it.

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #82093

You are most welcome & Thanks

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #82094

You are most welcome & Thanks

0
R
Rabah
Accepted Answer
3 years ago #89476

Dear Toufiq; hope all is well. wabted to check if there is an update with the educon template has override addon and needed to be compatible with Page Builder 4 & PHP 8

we took a while update our current site (we have limitted resources) and were updating both versions in hopes to get fix soon

could you let us know

thank you yousef

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #89540

Before update you should create an staging site and if staging site works fine then you should move it in your production site.

https://drive.google.com/file/d/1ms8hPQfM3xfF4XUO0W4pUZAhzGUqxBwD/view

  1. Create a subdomain from your cPanel
  2. Export your existing site Database from PHPMyAdmin
  3. Create a new Database
  4. Import the existing Database to the new Database
  5. Update configuration.php file
  6. Go to the administrator of the staging site
0
R
Rabah
Accepted Answer
3 years ago #89551

thank you for sharing, yes yes we already did a development site and updated Joomla to 4 the Educon template to latest version but we faced the 1064 Error. I was refereing to this origional post if there was an update on template fix

These are the pages with errors:

https://dev2.pniph.org/index.php/en/edit/35 https://dev2.pniph.org/index.php/en/edit/39 https://dev2.pniph.org/index.php/en/edit/53 https://dev2.pniph.org/index.php/en/component/tags/tag/rta

Screen shot from one them them https://prnt.sc/RHMz_hEuG996

Last time you mentioned that the educon template has override addon and needed to be compatible with Page Builder 4 & PHP 8.

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #89581

Except this issue everything is solved.

https://dev2.pniph.org/index.php/en/edit/53

I think this page doesn't exist or enabled.

0
R
Rabah
Accepted Answer
3 years ago #89584

Sorry for confusion. If you see origional post; the front end is mostly okay, but I meant editing any page gets all the errors. You may need to login (provided) to see. For example, clicking to edit the home page to edit, gets error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY lft ASC' at line 3

The following pages, also when we try to edit gets the same error: ID 35 ID 39 ID 53 ID 54 https://dev2.pniph.org/index.php/en/edit/35 https://dev2.pniph.org/index.php/en/edit/39 https://dev2.pniph.org/index.php/en/edit/53

Some images are not automatically taking the whole width automticllay like it did before https://dev2.pniph.org/index.php/en/about/stakeholders-and-partners https://dev2.pniph.org/index.php/en/component/content/article/mammography-screening-data-review?catid=92&Itemid=563

Here is specs currently: Current PHP version, 8.0 | Current Joomla version after upgrade: 4.1.5 Latest packages installed for Educon template: com_sppagebuilder_pro_v4.0.3 | educon_template Version 4.0.1 | com_splms_fullpackage_v4.0.7 | com_speasyimagegallery_fullpackage_v2.0.2

Thank you for your help!

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #89591

Can you join with me remote desktop using anydesk application?

0
R
Rabah
Accepted Answer
3 years ago #89596

Hi Toufiq, I tried but said its invalid

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #89600

Please try again.

0
R
Rabah
Accepted Answer
3 years ago #89608

Hi toufiq, sorry I tried again but it says the address is invalid.

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #89622

Check now. Thanks

0
R
Rabah
Accepted Answer
3 years ago #89627

Thank you so much.. The slider on the main homepage isn't loading either..

Do you recommend to update to latest joomla or hold on till a later release, later Educon update..etc?

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #89632

Hold on for the next release. Thanks

Both page editing works fine.

0