SQL and PHP issues and errors PLEASE HELP
Permalink
I have had to scrap all of my concrete5 sites about every 6 months and start fresh in order to deal with this... my host says it's a concrete5 programming issue, but no body in the help forums has been able to offer any solution other than checking the server settings...which i have done. What is going on again is that I can not add new Blocks to any of my pages! i can edit the ones which are already there. i've been editing my site for months with no issues, then all of a sudden this happens. I am attaching a copy of the error message which i get when i try to add any kind of block to a page (newly created or previously created). Is this a PHP issue? or mySQL issue?? I noticed that the topics which have the mySQL titles have no replies. has anyone had this same issue and found a solution??? thanks community! (I'll post back if/when i figure this out)... hopefully i do not have to do a fresh install again!!! it's very frustrating and I have a lot invested in C5 so I do not want to give up on it and try another program... especially if it's not a C5 issue but something else..... thanks for any help.
I would also like to note (if this makes any difference) that i seem to be able to add a new page and add the Forums block to it. I will try each block option to see which are working and which are not.... what i have been trying to add are the simple things like the content block.
Can you let us know:
- What version of concrete5 your are running
- the contents of your /concrete/elements/dialog_header.php file
The SQL statement it is complaining about is indeed invalid, it's missing a number after the keyword LIMIT.
I couldn't find that SQL statement in concrete5, but that could be because I'm simply not looking at the version you are using.
- What version of concrete5 your are running
- the contents of your /concrete/elements/dialog_header.php file
The SQL statement it is complaining about is indeed invalid, it's missing a number after the keyword LIMIT.
I couldn't find that SQL statement in concrete5, but that could be because I'm simply not looking at the version you are using.
I'm using 5.6.3.4 (i tried the upgrade but still had problems thinking it might be the newer version.... falling back to this version seemed to work initially, but had the same issues soon after anyway).
This is what is in my dialog_header.php file:
<?php defined('C5_EXECUTE') or die("Access Denied."); ?>
<?php /*
<div class="ccm-ui">
*/ ?>
<div>
This is what is in my dialog_header.php file:
<?php defined('C5_EXECUTE') or die("Access Denied."); ?>
<?php /*
<div class="ccm-ui">
*/ ?>
<div>
The SQL message in your screenshot is just not something I can find in the codebase:
https://github.com/concrete5/concrete5-legacy/search?utf8=%E2%9C%93&...
There are similar queries, but not the one that is throwing the error.
What packages have you got installed? I have a feeling it's not core code, but some sort of package script...
https://github.com/concrete5/concrete5-legacy/search?utf8=%E2%9C%93&...
There are similar queries, but not the one that is throwing the error.
What packages have you got installed? I have a feeling it's not core code, but some sort of package script...
i really appreciate your help. here's what I have installed:
i have Venture theme (mostly not using do to navigation issues)
my primary theme on the site is HeyDesigner.
Add On list:
Register User Pro
Keycaptcha
Mailing List
Pro Blog (which i do not use yet)
Discussion 1.8.6
Ajax member Directory
Pro Events (not using)
Pro Media (not using)
Pro News (not using)
List from file Set
Users pages
Registrant Group
Lerteco User Importer
PayPal Donations Box
Walkthrough (not using)
Forms with PayPay Payment
Site Notifications
PDF Viewer
Manual Nav
Parent Link
Sortable Fancybox Gallery
Not install yet:
Awkward Slider
Example FAQ
Page List Title
i have Venture theme (mostly not using do to navigation issues)
my primary theme on the site is HeyDesigner.
Add On list:
Register User Pro
Keycaptcha
Mailing List
Pro Blog (which i do not use yet)
Discussion 1.8.6
Ajax member Directory
Pro Events (not using)
Pro Media (not using)
Pro News (not using)
List from file Set
Users pages
Registrant Group
Lerteco User Importer
PayPal Donations Box
Walkthrough (not using)
Forms with PayPay Payment
Site Notifications
PDF Viewer
Manual Nav
Parent Link
Sortable Fancybox Gallery
Not install yet:
Awkward Slider
Example FAQ
Page List Title
oh wow...guess what.... I had an update for the Discussion Forum add-on that addressed a mySQL issue... so far after the update it looks like i can now add the common blocks again on any page!! woo hoo! i would have never thought it would effect unrelated pages!! i'm very happy, relieved and back to work!! fingers crossed! Thanks so much!
Great to hear!
Often packages run 'on_start' scripts on every page load, in case they need to do something, so that would explain why it would have affected seemingly unrelated pages.
Often packages run 'on_start' scripts on every page load, in case they need to do something, so that would explain why it would have affected seemingly unrelated pages.
