search

pivotx / PivotX

GNU General Public License v2.0
4 stars 5 forks source link

mysql error (it seems) #22

Closed bcmans closed 6 months ago

bcmans commented 9 months ago

Describe the bug

There was a problem with the Database:

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 'DESC, e.uid DESC ORDER BY e.date DESC LIMIT 8' at line 3

error code 1064

If you're in the process of setting up PivotX, you should review your [Database connection settings](https://kootenaychristianfellowship.com/dat/pivotx/index.php?page=configuration#section-2).
If it worked before, you should check if the Mysql database engine is still running on the server (or ask your systems administrator to check for you).

To Reproduce Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Expected behavior A clear and concise description of what you expected to happen.

Screenshots If applicable, add screenshots to help explain your problem.

System information:

Additional context Website was running fine for several months. https://kootenaychristianfellowship.com/dat/

hansfn commented 9 months ago

It seems your site works again. For the benefit of other readers: What did you do - clear cache? If the problem is indeed fixed, just close the issue.

bcmans commented 9 months ago

no not yet as like with this page https://kootenaychristianfellowship.com/dat/?p=sermons

it does not pull the entries. Same as the top of the homepage. The error message show in the backend (dashboard)

brainexcerpts commented 9 months ago

image image

I clicked your link and a few others and it seems to work on my side.

Now maybe it's a bug similar to the flat file db bug in which case it would be triggered quite randomly, you would still have to fix it each time by "re-building the index" in the "maintenance tab", so did you do anything of that sort?

bcmans commented 9 months ago

yes i did and in the mean time i moved it to a different server (without any problems) will test more on the old server with the hostpapa to see what the problem is. Will keep you informed

hansfn commented 9 months ago

Try to enable DB query logging on the old server so we get the complete query that fails.

hansfn commented 6 months ago

Closing until new information is provided.