Transfer vault information to SQL - Page 3

**Bugsy** · 12-30-2023 , 12:30 Re: Transfer vault information to SQL

I updated the above code with this change

amirwolf · 12-30-2023 , 13:23 Re: Transfer vault information to SQL

Code:

L 12/30/2023 - 21:52:08: [AMXX] Plugin ("test.amxx") is setting itself as failed.
L 12/30/2023 - 21:52:08: [AMXX] Plugin says: 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 ' , , '', '')' at line 1
L 12/30/2023 - 21:52:08: [AMXX] Run time error 1 (plugin "test.amxx") - forced exit

**Bugsy** · *Last edited by Bugsy; 12-30-2023 at 13:43.*

Looking at your prior post, the SQL statement is missing values so the parse isn't working as expected:

INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('30', , , , '', '');

Provide some sample nVault records, or send me the nVault file and I can look.

amirwolf · 12-31-2023 , 09:27 Re: Transfer vault information to SQL

Because I had not reached a conclusion and had little time, I entered all the items manually
Thanks to all of you

**Bugsy** · 12-31-2023 , 11:04 Re: Transfer vault information to SQL

Provide adequate information and this could have been completed quickly.