Staff replied SP Page Builder

Deleting a Dynamic Content Collection throws an error

Asked by Chris Elliott 1 year ago Last activity 1 year ago

I created a DC and created an item into the collection. All Good.

I then chose to add a new custom field to the collection. Added and updated ok.

Went to add content to the existing item to add info the new field, on Save I see:

"Something went wrong. Please try again later."

Decided to start again by deleting the Collection. On confirming the deletion (typing the alias into the box) and hitting Delete, I see:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS collection WHERE collection.id = 1' at line 2

Please advise?

7 replies

Toufiq Senior Staff

1 year ago

Hi there,

Thank you for reaching out, and I apologize for any inconvenience caused by this oversight. To better address the issue, could you kindly provide Joomla administrator access? This will enable me to thoroughly investigate the matter and provide you with a prompt resolution.

I appreciate your cooperation and will ensure to get back to you as soon as possible.

Best regards,

Toufiqur Rahman (Team Lead, Support)

Michel

1 year ago

Exactly the same problem on my side.

Toufiq Senior Staff

1 year ago

Could you kindly grant me access to your Joomla administrator area so that I can investigate the issue you're experiencing? Prior to providing access, please ensure that you have backed up your site. Additionally, it's important to note that providing login credentials is entirely voluntary on your part; we respect your decision either way. However, if you do choose to share the login details, it would greatly expedite the resolution process. Thank you for your cooperation.

Michel

1 year ago

Not possible for me, may be Chris could give you access.

Standa

1 year ago

Same problem. SAVE. Something went wrong. Please try again later.

first insert OK, edit and SAVE > "Something went wrong. Please try again later."

so can't edit/modify items again

joomla admin attached

Toufiq Senior Staff

1 year ago

@Standa Please downgrade PHP version 8.2 and let me know.

Save issue solved.

Chris Elliott Asked this

1 year ago

You are of course joking?

Standa

1 year ago

downgrade PHP version 8.1 - OK

it's a test and help here. Testing news.

Hopefully this can make it easier for users. Inserting text, gallery in the form of articles is still challenging for users.

Toufiq Senior Staff

1 year ago

Wait please. We just release a massive update. We deed to stable it. Then we can go forward. By the way thank you for being with us. Thanks

Chris Elliott Asked this

1 year ago

Ok Toufiq,

Even though I'm not the only person to report this issue (which indicates you should be able to reproduce it), I will give you access. See in hidden details.

Note this is a LIVE site. I have taken a backup.

Toufiq Senior Staff

1 year ago

Username and password do not match or you do not have an account yet.

Chris Elliott Asked this

1 year ago

Try now.

Toufiq Senior Staff

1 year ago

Please check now. Thanks

Chris Elliott Asked this

1 year ago

Thanks - can you clarify what the issue was?

Toufiq Senior Staff

1 year ago

Installed a patch on your site.