(2023-06-03, 06:14 AM)HAFOOCH Wrote: [ -> ]can you clarify a bit more?
what is actually the whole "CREATE TABLE" statement that i need to remove?
not sure exactly what you meant about phpmyadmin for making it work.. would you clarify?
I think the simplest way for you is to replace any occurence of
CREATE TABLE
with
CREATE TABLE IF NOT EXISTS
.
And also to learn basics of SQL language
Fixed typo.
CREATE TABLE IF NOT EXISTS
Admittedly, there's a lot to learn how the system works, Apache, SQL, PHP.
Thanks for the hint. Another thing to remember.
Also, the CRLF vs LF comment I made earlier about line breaks *may* affect how the file is read and processed. Although they may not matter if they are stripped out and the stream is processed using the semicolon delimiter. I'm not sure, and have never tested it on my server instance.
(2023-06-03, 02:16 PM)HLFadmin Wrote: [ -> ]Fixed typo.
CREATE TABLE IF NOT EXISTS
My bad, typed too quick
all occurences.
You did it for mybb_adminlog and the error is on mybb_adminoptions
(2023-06-04, 10:44 AM)Crazycat Wrote: [ -> ]all occurences.
You did it for mybb_adminlog and the error is on mybb_adminoptions
what do you mean?
what do i need to change?
(2023-06-03, 01:18 PM)Crazycat Wrote: [ -> ]I think the simplest way for you is to replace any occurence of CREATE TABLE
with CREATE TABLE IF NOT EXISTS
.
And also to learn basics of SQL language
If not clear enough - not sure how it could be made plainer.
you mean that i need to search and replace all occurrences of "CREATE TABLE" with "CREATE TABLE IF NOT EXISTS" in the sql backup file?
that's it?
i've replaced all "CREATE TABLE" with "CREATE TABLE IF NOT EXISTS"
but got that..
[
attachment=46032]
Ok, so drop your tables and run the sql.
I don't know how you messed up your installation, and don't want to read all the thread.
1. Backup actual base
2. Remove it (the base, not the backup)
3. Import the SQL.
do you mean that something in the fresh installation went bad too?
please explain more clearly if you can..
i don't even know what is 'base'.. perhaps a backup without the structure??
i wish it was easier to use such systems....
i'm so tired of this but really want to keep working on my content on the forums again..
everytime there is an update something like that happens