Recent issues with the network | Forum

Owner/Admin
Owner/Admin Jul 10
As you may have notice there are some issues with the network. Mainly messages dont send and blogs  dont work  toname a coulpe. Here is what support told me.


Hello,


Thank you for your patience.

Note that the errors generated is the following:

SQLSTATE[42000]: Syntax error or access violation: 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 'DESC, `m` DESC' at line 4

This is a syntax error which indicates your database syntax is incompatible with MYSQL 8. Note that this issue appears to have been present even before downgrading as the previous server on which you resided was with the exact same MySQL Version and configuration.

I would recommend contacting a certified MySQL expert who'd be able to review the error and the database syntax and apply the necessary changes. And if any changes are required on our end, simply update us via this ticket with the specifics and we will gladly assist you accordingly.

If you need further assistance, feel free to contact us at any time as we are 24/7 at your disposal.

Best Regards,




If anyone can be of assistance here please let me know. 

The Forum post is edited by Owner/Admin Jul 10
Share:
Cornelius Coburn
I'm not sure what else can be said. This is what happens when the PHP database code within the forum pages gets old as the host server MySQL software(or engine) is continually upgraded to the point where the forum syntax(code) becomes more and more obsolete over time, as has been seen here, and as Anna said(paraphrased), "It's only a matter of time".


Either someone needs to fix the database code, or the forum software needs to be updated - most probably just do the update because it's the easiest, although the most pricey I would think. It probably wouldn't be cheap to pay someone to do it either.


I would just take at look at the code where it says and compare it with the newer syntax. I think "DESC"(descending) syntax is still valid but it's the probably the way the code segment is written that is obsolete.


The code opens a MySQL database table which is a multi-dimensional array of data, and then sorts descending order by the first field(usually a date and time) within the table.


I've only worked with Microsoft Jet databases in the past, plus a whole slew of other shit - same idea; different syntax.


Right now I got a car with a flat sitting in the driveway that I haven't really given much of a shit about for the past two days.




Owner/Admin
Owner/Admin Aug 11
Thanks for the info. Seems somehow some of the errors managed to fix themselves. Updating is not possible. As oxwall software stopped updating in 2015 . So maybe this network will be archived like the 600 club in the near future .
Dark Enlightenment
Based on the error, it seems like there is a problem with the syntax of the ORDER BY clause in your SQL code. To fix this error and make it compatible with MySQL 8, you need to ensure that the column names are enclosed in backticks (`) if they contain reserved words or special characters. Assuming that `DESC` and `m` are column names, the fixed SQL statement would be: 


 ```sql 

SELECT * 

FROM your_table

 ORDER BY `DESC` DESC, `m` DESC;

 ```

 In this fixed query, both the `DESC` and `m` column names have been enclosed in backticks to avoid any syntax conflicts or errors. 


 - Chat GPT



To interpret that I suggest trying to change:


'Desc, `m` Desc'


to


`DESC` DESC, `m` DESC;


On line 4 of the SQL code. 


The Forum post is edited by Dark Enlightenment Sep 4
Owner/Admin
Owner/Admin Sep 22
Thanks DE . I am not even sure how to do this but will look into it
Satanic International Network was created by Zach Black in 2009.
Certain features and pages can only be viewed by registered users.

Join Now

Spread the Word. Help Us Grow

Share:

Donate - PayPal