Daily Lucky Numbers:
12
16
18
29
33
49

Recent posts

#1
Site Discussion / Re: Recent slow response time ...
Last post by Chen Zhen - Today at 07:54:31 AM
Actually..  it might have been the scheduled backup.
#2
Site Discussion / Recent slow response time with...
Last post by Chen Zhen - June 01, 2024, 11:54:28 PM

For some unknown reason the site is a bit slow lately and I'm looking into it.
My apologies for the inconvenience.
#3
SMF Arcade Support + Plugins / Re: Arcade install
Last post by Chen Zhen - June 01, 2024, 11:20:33 PM
Just ask your host not to use hyphens in their database names because those are reserved characters.
They need to be using underscores & they should know this since they're providing a hosting service.

In order to have hyphens in database names, SMF developers would have to wrap the database names in all their native db queries within backticks. They haven't done that with many of their native functions so you're going to see errors like that for many mods that use any of the extended functions.

I can do that in my mods but it involves creating my own functions for various tasks instead of using SMF's native ones plus I'd have to try and accommodate multiple database types. This is too much work.. the simple solution is not to use hyphens in database names.

ref.
https://dev.mysql.com/doc/refman/8.4/en/identifiers.html
#4
SMF Arcade Support + Plugins / Re: Arcade install
Last post by Vincent Titus - June 01, 2024, 04:16:08 PM
no its not free i paid for a life time subscription before i knew about this but ill see if they can do anything, thats why i would like to use them ill figure something out ty chen for looking into it
#5
SMF Arcade Support + Plugins / Re: Arcade install
Last post by Chen Zhen - May 31, 2024, 09:28:50 PM
The Arcade installer uses many SMF native database package functions which aren't currently developed to handle reserved DB characters in the schema name(s) structure. The hyphen in your database name is what's causing the issue.

I created a database that contained a hyphen for testing and attempted to patch the installer to handle this scenario but the rabbit hole runs deep. It's too much work to attempt to circumvent this scenario so I suggest finding another host.
Is this host offering free service? If it's paid then ask them to create a database for you that doesn't include any reserved characters. If it's a free host then I suggest finding some cheap hosting. If you contact Skhilled on this site he can likely set you up with something for a low cost & some support. 

Here is his website: https://www.docskillz.com/docs

#6
SMF Arcade Support + Plugins / Re: Arcade install
Last post by Vincent Titus - May 20, 2024, 07:34:02 PM
heres the complete data base, i have no idea what im looking for lol not a coder maybe someone can have a look at it
#7
SMF Arcade Support + Plugins / Re: Arcade install
Last post by Vincent Titus - May 20, 2024, 11:47:22 AM
and they splitup the DB for performance i guess

#8
SMF Arcade Support + Plugins / Re: Arcade install
Last post by Vincent Titus - May 20, 2024, 11:39:01 AM
yes i have used the backtick to fix the install of your battle mod witch worked and i was able to get that installed but not sure where to place the backtics in the arcade... and my host creates the database automasicly when i installed smf, i cant create one myself, still not sure where to make the changes in the DB..
#9
SMF Arcade Support + Plugins / Re: Arcade install
Last post by Chen Zhen - May 18, 2024, 10:18:52 PM
I apologize for not being around much as of late.
It isn't recommended to use improper characters for your db schema (db names,table names or column names) although I did attempt to have the installer try to circumvent any errors when it encounters those characters.

ref.
https://stackoverflow.com/questions/925696/mysql-create-database-with-special-characters-in-the-name

An option for you is to copy your DB for download (for safety) & then alter it to not contain any illegal characters.
Afterward you may have to use the SMF tool to fix any reference to the older db table names.
Having your DB backup available can fix things if you have trouble while trying to do this.
 
#10
SMF Arcade Support + Plugins / Re: Arcade install
Last post by Vincent Titus - May 16, 2024, 04:05:02 PM
So I was having the same error when I tryed to install the battle mod so in order to fix that I had to add the backtick to a couple parts of the 2 files dealing with the data base and I was able to install the battle mod and all is well so I need to find where I need to add the backtick like this '{ $data_base }' that's not the back tick it's the one pointing the other way I can't do it from my phone but you get what I mean in the database files... I'll figure it out eventually lol