0
Welcome Guest! Login
0 items Join Now

Adding SQL information???

Last Post
Search Topic

  • Adding SQL information???

    Posted 15 years 6 months ago
    • So I finally finished the main portion of my rockettheme and then realized I didn't transfer my customers over yet. I found the sql information that i needed to insert.

      When I went to insert it into
      " Run SQL query/queries on server "giellastore.db.4244538.hostedresource.com": "
      It gave me an error. Whats the correct way to add sql information into a file? I have deleted the passwords and added "???"

      INSERT INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES
      (63, 'tj giella', 'italiancorolla', 'This email address is being protected from spambots. You need JavaScript enabled to view it.', '????', 'Registered', 0, 0, 18, '2009-09-02 07:19:04', '2009-09-11 04:07:44', '', 'page_title=Edit Your Details\nshow_page_title=1\nlanguage=\ntimezone=-5\n\n'),
      (66, 'Shea McPeak', 'ninjasam2355', 'This email address is being protected from spambots. You need JavaScript enabled to view it.', '????', 'Registered', 0, 0, 18, '2009-09-14 00:56:05', '2009-09-14 06:38:59', '', '\n'),
      (65, 'Levester Best', 'labest', 'This email address is being protected from spambots. You need JavaScript enabled to view it.', '????, 'Registered', 0, 0, 18, '2009-09-11 10:53:16', '2009-09-11 18:47:13', '', 'language=\ntimezone=-5\n\n'),
      (68, 'Robert C Witte', 'trinitytrike', 'This email address is being protected from spambots. You need JavaScript enabled to view it.', '????, 'Registered', 0, 0, 18, '2009-09-21 07:25:56', '2009-09-21 12:27:20', '', 'language=\ntimezone=-5\n\n'),
      (69, 'Wilson To', 'llyllkay', 'This email address is being protected from spambots. You need JavaScript enabled to view it.', '????', 'Registered', 0, 0, 18, '2009-10-06 17:08:55', '2009-10-08 06:18:01', '', '\n'),
      (71, 'brian chau', 'brianc825', 'This email address is being protected from spambots. You need JavaScript enabled to view it.', '???', 'Registered', 0, 0, 18, '2009-10-18 00:23:07', '2009-10-18 05:25:14', '', '\n');
    #407474

  • Re: Adding SQL information???

    Posted 15 years 6 months ago
    • How about this thread ?
      You will need to look at these tables:
      jos_users
      jos_core_acl_aro
      jos_core_acl_groups_aro_map
    #408112

Time to create page: 0.064 seconds