You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-353035397ab4' at line 1
File: /home/sites/36b/7/7588baaf12/public_html/Packages/temp/arcadeinstall/Database.php
Line: 16
any help on this cant get the arcade to install
Hi Vincent,
It's possible that it wont install as you have it in a 'temp' folder within the Packages directory. All mods should be directly in the packages directory or the database doesn't know where to look for them
Omg ty for replying I will try that but the zip is in the package folder should i unzip it first and place it in the package folder ???
I think it's because there's a dash in the data base name and that's created by my host provider and I can't change it
What I need is the a sql file for the whole arcade database install and I could install it manually
What you need to do is remove the zip file from the 'Packages' folder first. Then go to 'Admin► Package Manager► Add Packages' then use the 'Choose File' button and go to where the zip file is stored on your PC click on the zip file and click on 'Upload' to add the zip file.
Once the file has been added the window will change and then all you need to do is to click on 'Install Mod' and that should install the mod for you. If you see any install errors in red that means that you have to edit thse templates/files manually.
The underscore in your database's tables/name will make no difference to the install of the mods, if you have a working SMF site then it proves that these are OK.
I hope that helps
yes i know but this happenes
i can get to the last step then get the error when i click install
i think because of the - ( dash ) in the database name in the database.php file the $database_name or something needs to be in quots because the dash is a special character
Hmmm...I still don't know why it's showing the file in a temp folder within the Packages folder.
I'm sorry Vincent I really can't help any more
yeah the temp folder gets created automadily from the package installer and once any install is complete it deletes the contents ill have to wait for chen to wake up i guess lol tyvm for trying
Quote from: Vincent Titus on May 01, 2024, 11:59:47 AMyeah the temp folder gets created automadily from the package installer and once any install is complete it deletes the contents
You learn something new every day, I hope he replies soon for you. I haven't seen him for months
You could do me a favor you have a test site correct and if so, could you install SF 2.1 and then install the arcade the newest version I guess and then once it's all installed, can you export the database for the whole thing and post it here and I'll make the necessary changes for my site and then upload the SQL Database
Here you go Vincent, see how you get on with this
Oh wow brother thank you soooo much I'll try it once I get off work tonight
That just the arcade data base and not and right ?? It looks it when I looked at it
Yes it's just the arcade tables.
You probably already know this but I'm going to say it anyway. All you should need to do it make sure there are no arcade tables already in your database, change the table prefixes to match your own database and copy and paste the whole of the text into the SQL box in phpmyadmin then click on go and it will add the tables, if it says 'are you sure you want to' then click on yes and proceed, see image attached
yeah didnt work lol i think i need a database of the arcade allready installed on a copy of smf the file you gave me installed no problem but still shows i need to install it all on smf and i get the error
ex: install smf
install arcade
export the whole data base
its because my host has special characters in the database name EX: '-353035397ab4' the dash and me or them are unable to change it they said
Quote from: Vincent Titus on May 02, 2024, 09:29:50 AMits because my host has special characters in the database name EX: '-353035397ab4' the dash and me or them are unable to change it they said
Ask vgamer to help you with this.
If you have access to phpmyadmin, you might also want to check the db and see if all of the table collations are the same AND are the same that the server is set to...
Looks good yes
I have other mods that installed with no problems so why this one
I get a permission error forbidden when I try to use package manager manager to upload the file
Now that I look more at the following, I haven't seen numbers in a hosting's path like this in a LONG time and I've been surfing the net for 35+ years...after '/home/sites/'.
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-353035397ab4' at line 1
File: /home/sites/36b/7/7588baaf12/public_html/Packages/temp/arcadeinstall/Database.php
Line: 16
I'm no expert but I'm thinking that it's either hosting related to the db and/or up may need to upgrade your forum, db, etc. to the latest versions starting with using SMF's upgrade.php which will make sure that the your db is upgraded to the latest version. Other than that, I've got nothing else...
Yeah when I install a site using their quick install , it automatically creates the database I can not create one myself it doesn't let me they put that at the end so there's no conflict between anyone on their servers . I will try the update grade.php but I am using 2.1 tyvm for trying
The thing is I installed the portal mode and other mods with no problems at all , why the arcade ??
Then another mod may be conflicting with it, perhaps?
no i tryed the arcade first thing with out any other mods installed then i tryed other mods to see if it happenes and they all work fine
ok i was able to get by the database.php file by changing it to
if (strpos($db_name, '.') === false) {
$result = $smcFunc['db_query']('', "SHOW TABLE STATUS FROM `{raw:db_name}`", array('db_name' => $db_name));
} else {
$result = $smcFunc['db_query']('', 'SHOW TABLE STATUS FROM `' . $db_name . '`', array());
}
by adding the backtick ` here `{raw:db_name}`" and here `' . $db_name . '`',
i assume ill have to do that to all including the other files like Sub_install.php because now the error is on Sub_install.php file lol
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-353035393de2
LIKE 'smf_arcade_games'' at line 2
File: /home/sites/36b/7/7588baaf12/public_html/Packages/temp/arcadeinstall/Subs-Install.php
Line: 57
so i found this on the error logs of my host
PHP Parse error: syntax error, unexpected single-quoted string "{db_prefix}", expecting ")" in
/arcadeinstall/Subs-Install.php on line 53'
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
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.
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..
and they splitup the DB for performance i guess
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