Query SQL error

gabsik · 07-19-2006, 03:18 AM

That's the best i can do

Code:

mysql> INSERT INTO jos_users('name','username','email','password','usertype','block','gid','registerDate')VALUES('maria','maria','maria@gabrix.ath.cx','949d68ce38121db707017970fc91711a','','1','18','2006-07-19 10:21:07','7503270c7d8facb28d91e54284b64302');
ERROR 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 ''name','username','email','password','usertype','block','gid','

What i didn't get at all is:
I have to register a new user straight into sql with new values right ?
The values for name email ecc. are all right but what for an encripted password value , gid , block , usertype ecc. ???

spirit receiver · 07-19-2006, 04:44 AM

Try this

Code:

INSERT INTO jos_users
   (name,username,email,password,usertype,block,gid,registerDate)
VALUES
   ('maria','maria','maria@gabrix.ath.cx','949d68ce38121db707017970fc91711a','','1','18','2006-07-19 10:21:07');

As for the last question: We don't even know the program you're using, so how could we know about the meaning of gid, block, usertype? And "encrypted password" seems to be, well, an encrypted password. If you want to know how that encryption is done, you'll have to inspect the code of the program again.

gabsik · 07-19-2006, 07:09 PM

It looks good:

Code:

mysql> INSERT INTO jos_users(name,username,email,password,usertype,block,gid,registerDate)VALUES('maria','maria','maria@gabrix.ath.cx','949d68ce38121db707017970fc91711a','','1','18','2006-07-19 10:21:07');
Query OK, 1 row affected (0.00 sec)

but

Code:

mosuser::store failed <br/>Unknown column 'activation' in 'field list' SQL=INSET INTO jos_users('id','name','username','email','password','usertype','block','gid','registerDate','activation'....

As you see it's still that 'activation' ... there .... !!!
Sorry I have a debian sarge 3.1 2.6 stable with the latest software ... stable .
(???)

spirit receiver · 07-20-2006, 01:46 AM

I already asked where that statement is issued, that's where you'll have to change it. This has nothing to do with your distribution or with MySQL, but with the program you're using. Search your 'latest software' for that SQL command.

white_cafee · 07-20-2006, 02:49 AM

I have the same problem ....i've tried even reinsall the hole linux system and still no answer...

gabsik · 07-20-2006, 09:59 AM

And i'm using Joomla as cms !

gabsik · 07-22-2006, 12:00 AM

That's the table jos_users.It has the auto_increment set:

Code:

mysql> describe jos_users;
+-----------------------+-----------------------+------+-----+---------------------+----------------+
| Field                 | Type                  | Null | Key | Default             | Extra          |
+-----------------------+-----------------------+------+-----+---------------------+----------------+
| id                    | mediumint(9)          |      | PRI | NULL                | auto_increment |

I insert the new coloms and values into it:

Code:

mysql> INSERT INTO jos_users(name,username,email,password,usertype,block,gid,registerDate)VALUES('ciro','ciro','ciro@gabrix.ath.cx','949d68ce38121db707017970fc91711a','','1','18','2006-07-19 10:21:07');
Query OK, 1 row affected (0.00 sec)

But:

Code:

mosuser::store failed<br/>Unknown column 'activation' in 'field list' SQL=INSERT INTO jos_users('id','name','username'.'email','password','usertype','block','gid','registerDate','activation' )VALUES ('0','angela','angela','angela@yahoo.it','36388794be2cf5f298978498ff3c64a2','','1','18','2006-07-22 06:40:42','7de918be9fce9e683d16e5eac0a5ce80')

How do i delete that 'activation'?
I have changed values but 'id' and '0' are still there ...
Please help !!!!

spirit receiver · 07-22-2006, 02:34 AM

http://www.mambers.com/archive/index.php/t-33109.html
http://forum.phil-taylor.com/viewtop...6ae56ea70b8a13