Mysql1046 error solving mysql 1046 error solving:
Require_once './include/common. inc. php ';
$ Maxpostnum = 200; // sets the minimum number of posts.
If (! $ Discuz_user |! $ Discuz_pw ){
Showmessage ('sorry, you have not logged on. you cannot perform this operation. ');
}
If (! $ Adminid ){
$ Query = $ db-> query ("SELECT postnum, credit FROM bbs. cdb_members WHERE username = '$ discuz_user '");
$ Blogaccess = $ db-> fetch_array ($ query );
If ($ blogaccess ['postnum'] <$ maxpostnum ){
Showmessage ('sorry, you have not activated the RSS aggregation service ');
}
}
$ Query = $ db-> query ("SELECT username FROM uploader. uploader_users WHERE username = '$ discuz_user '");
$ Bloguser = $ db-> fetch_array ($ query );
If ($ action = ""){
Include template ('RSS _ reg ');
}
If ($ action = "kaihu "){
If (! $ Bloguser ['user']) {
$ Query = $ db-> query ("SELECT uid, username, password, email, regdate FROM bbs. cdb_members WHERE username = '$ discuz_user '");
$ Bloginfo = $ db-> fetch_array ($ query );
$ Db-> query ("insert into uploader. uploader_users (username, password, email, reg_date)
VALUES ('$ bloginfo [username]', '$ bloginfo [password]', '$ bloginfo [email]', '$ bloginfo [regdate]' ");
$ Db-> query ("UPDATE bbs. cdb_members SET rss = 1 WHERE username = '$ discuz_user '");
Showmessage ('After the account is activated, you can go to manage ', 'http: // rss. twbbs. Biz ');
} Else {
$ Db-> query ("UPDATE bbs. cdb_members SET rss = 1 WHERE username = '$ discuz_user '");
Showmessage ('Your account has been activated ', 'http: // rss. twbbs. Biz ');
}
}
?>
SQL: INSERT INTO uploader. uploader_users (username, password, email, reg_date)
VALUES ('sa ', '40c76244e235aa23e73acb4a457f9748', 'sa @ gmail.com ', '123'
Error: 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 2
Errno.: 1064
Required