Recent issues with the network | Forum

Owner/Admin
Owner/Admin Jul 10 '23
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 '23
Share:
Cornelius Coburn
Cornelius Coburn Jul 11 '23
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 '23
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
Dark Enlightenment Sep 4 '23
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 '23
Owner/Admin
Owner/Admin Sep 22 '23
Thanks DE . I am not even sure how to do this but will look into it
Cornelius Coburn
Code can be daunting if you're not a programmer, and even if you are the syntax can vary from language to language. It might even be the same language but code written by someone else can also add a layer of difficulty.


Assuming you have write, modify, and delete privileges on the server where the Oxwall code resides you can just locate and open up the file. The path to the file is in the error ending in .../database.php line 723 it says on my error.


You could make a copy of the file before you change anything and if it goes south you can just delete the one you messed up and replace it with the one you saved - lather rinse and repeat or whatever.


I've never programmed with PHP or worked with MySQL. I started with COBOL, and then Visual C++(and MFC) which is similar to PHP, and also some scripting like Javascript. Mostly Microsofts' shit, and I could keep going on and on with the acronyms - DAO, ADO, ASP yadda yadda.


It's been a while though. I haven't done anything since the early 2000s. Nowadays it's all the mundane shit and then driving, writing, and working on cars in my free time, and who the fuck knows what else, but no programming.

The Forum post is edited by Cornelius Coburn Feb 12
Cornelius Coburn
I know though, what's the point right? Nobody seems to give a shit about these old-style niche forums any more. Lots stick their foot in the door, but the member to writer ratio is baffling. The few of us that do pick up a pen might as well be contemporary circus freaks.


The countless occult forums and many other characteristic cohort conclaves have concurrently chartered a parallel course to quietness. The steady mainstream status quo continues quite well, but that's about it.

The Forum post is edited by Cornelius Coburn Feb 13
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