MyBB Community Forums

Full Version: database upload issue
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
i have moved my website from my domain path warhood.com/android
to androidfreaks.nl and i was trying to add the database into androidfreaks.nl and this is what i get:
Notice in ./libraries/sql-parser/src/UtfString.php#134
[Image: dot.gif] Uninitialized string offset: 127

Backtrace

./libraries/sql-parser/src/Lexer.php#769: SqlParser\UtfString->offsetGet(integer 65)
./libraries/sql-parser/src/Lexer.php#258: SqlParser\Lexer->parseString()
./libraries/sql-parser/src/Lexer.php#210: SqlParser\Lexer->lex()
./libraries/Util.class.php#634: SqlParser\Lexer->__construct(string )
./import.php#750: PMA_Util::mysqlDie(
string '#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 \'\' at line 1',
string ,
boolean false,
string 'db_import.php?db=android1_website&token=e1b180408d8bff4b8480f9c5c225171f',
boolean true,
)


extra:
Fout
Statische analyse:
9 fouten werden gevonden tijdens de analyse.
  1. Onverwachte letter. (near "" at position 0)
  2. Onverwacht begin van opdracht. (near "" at position 0)
  3. Onverwacht begin van opdracht. (near "�n�0" at position 1)
  4. Onverwacht begin van opdracht. (near "h���Y� ����N�!Y" at position 3)
  5. Onverwacht begin van opdracht. (near "�I�/����o�q" at position 12)
  6. Onverwacht begin van opdracht. (near "V" at position 18)
  7. Onverwacht begin van opdracht. (near "@�Ň9Y�k�D�Z�9x�" at position 19)
  8. Onverwacht begin van opdracht. (near "“" at position 29)
  9. Onverwacht begin van opdracht. (near "" at position 33)
SQL-query:

MySQL meldt: [Image: dot.gif]
#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 '' at line 1


and there are many problems like this, how i can solve this problem?
kind regards,
Michael.

inc/settings.php and inc/config.php are edited to androidfreaks.nl so that's not the problem it's only the mysql database.
if you are using compressed database (eg. .sql.gz) then decompress it and try to import plain database (.sql file)
oke i saved all the files, but somehow he still sees warhood.com as the main website i change everytime and save it.... and after save guess what... warhood.com again is the website.
looks like your browser cache is affecting. have you tried with another browser ..
somehow everytime when i save inc/settings.php the php script will change itself after 5 minutes, to my old domain.....
how i can solve that problem? im using WinSCP
after saving settings.php file,
login to forum admin panel, navigate to Site Details section & change settings there (again) & save the settings.
thanks now it works Smile