error importing database AKCore

[m0nt1lla]

if anyone can help me with this error I'd appreciate lifetime ^^

[MentaL]

[ATIDOT3]

Use navicat.

[m0nt1lla]

Use navicat.

I feel the same with navicat



"[Err] 1655 - Cannot create stored routine `AuthLogin`. Check warnings[Err] CREATE DEFINER=`root`@`%` PROCEDURE `AuthLogin`(IN m_szUserID VARCHAR(20), IN m_szUserPW VARCHAR(20), OUT m_dwAccountID INT, OUT m_nResultCode INT)
BEGIN


DECLARE dec_pw VARCHAR(100);
DECLARE dec_status VARCHAR(7);


IF(SELECT EXISTS(SELECT 1 FROM accounts WHERE Username = m_szUserID)) THEN
SELECT AccountID,AccountPW,acc_status INTO m_dwAccountID,dec_pw,dec_status
FROM accounts
WHERE Username = m_szUserID;


IF (dec_pw = m_szUserPW) THEN
SET m_nResultCode = 100;
ELSE
SET m_nResultCode = 107;
END IF;
IF (dec_status = 'block') THEN
SET m_nResultCode = 113;
END IF;


ELSE
SET m_nResultCode = 108;
END IF;


END
;
[Msg] Finished - Unsuccessfully
--------------------------------------------------"

[ATIDOT3]

Try with the new one from the github, kalisto changed some thing about the procedure earlier, maybe it's gonna work.

[SanGawku]

I did change it so the definer was Root@Localhost so this is outdated sql.

[m0nt1lla]

I did change it so the definer was Root@Localhost so this is outdated sql.

already solved, what happened was I was using AppServ so gave me that error


AppServ so uninstall and install Xampp and now if I work


But now I have a problem when trying to build solution


Best downloaded Visual Studio Ultimate and see if it works so I

[SanGawku]

Visual Studio 2010 Ultimate is what you need to compile with. :)

[m0nt1lla]

thanks for the tips and for your supports


you are the first group that I see that if you are interested in helping others that we have problems ^^


thank you very much


keep it ^^