LinuxQuestions.org
Latest LQ Deal: Latest LQ Deals
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 07-19-2006, 03:18 AM   #31
gabsik
Member
 
Registered: Dec 2005
Location: This planet
Distribution: Debian,Xubuntu
Posts: 567

Original Poster
Rep: Reputation: 30

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. ???

Last edited by gabsik; 07-19-2006 at 03:30 AM.
 
Old 07-19-2006, 04:44 AM   #32
spirit receiver
Member
 
Registered: May 2006
Location: Frankfurt, Germany
Distribution: SUSE 10.2
Posts: 424

Rep: Reputation: 33
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.
 
Old 07-19-2006, 07:09 PM   #33
gabsik
Member
 
Registered: Dec 2005
Location: This planet
Distribution: Debian,Xubuntu
Posts: 567

Original Poster
Rep: Reputation: 30
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 .
(???)

Last edited by gabsik; 07-19-2006 at 07:14 PM.
 
Old 07-20-2006, 01:46 AM   #34
spirit receiver
Member
 
Registered: May 2006
Location: Frankfurt, Germany
Distribution: SUSE 10.2
Posts: 424

Rep: Reputation: 33
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.
 
Old 07-20-2006, 02:49 AM   #35
white_cafee
LQ Newbie
 
Registered: Jul 2006
Posts: 12

Rep: Reputation: 0
I have the same problem ....i've tried even reinsall the hole linux system and still no answer...
 
Old 07-20-2006, 09:59 AM   #36
gabsik
Member
 
Registered: Dec 2005
Location: This planet
Distribution: Debian,Xubuntu
Posts: 567

Original Poster
Rep: Reputation: 30
And i'm using Joomla as cms !
 
Old 07-22-2006, 12:00 AM   #37
gabsik
Member
 
Registered: Dec 2005
Location: This planet
Distribution: Debian,Xubuntu
Posts: 567

Original Poster
Rep: Reputation: 30
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 !!!!
 
Old 07-22-2006, 02:34 AM   #38
spirit receiver
Member
 
Registered: May 2006
Location: Frankfurt, Germany
Distribution: SUSE 10.2
Posts: 424

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


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL query performance smaida Programming 6 06-08-2005 09:22 AM
Query tool for MS-SQL server dunric Linux - Software 0 11-14-2004 11:39 AM
SQL query help pls. vickr1z Programming 8 10-18-2004 11:25 PM
Massive SQL Query patpawlowski Programming 7 03-05-2004 04:24 PM
SQL Query question oulevon Programming 7 01-16-2004 01:50 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 03:22 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration