can you say it one more time?ATek wrote:nebyl - You rock!
Happy to help
Moderator: General Support Moderators
can you say it one more time?ATek wrote:nebyl - You rock!
nebyl wrote:can you say it one more time?ATek wrote:nebyl - You rock!
Happy to help
Code: Select all
function register_save()
{
Code: Select all
Profile Information
Application afterLoad: 0.000 seconds, 0.23 MB
Application afterInitialise: 0.082 seconds, 4.19 MB
Application afterRoute: 0.097 seconds, 4.85 MB
Application afterDispatch: 0.149 seconds, 7.32 MB
Application afterRender: 0.281 seconds, 13.24 MB
Memory Usage
13967244
37 queries logged
1. SELECT *
FROM jos_session
WHERE session_id = 'e10592a543ebeb836cc7c5a95e0424a8'
2. DELETE
FROM jos_session
WHERE ( TIME < '1342481268' )
3. SELECT *
FROM jos_session
WHERE session_id = 'e10592a543ebeb836cc7c5a95e0424a8'
4. UPDATE `jos_session`
SET `time`='1342482168',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:10:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1342482146;s:18:\"session.timer.last\";i:1342482154;s:17:\"session.timer.now\";i:1342482168;s:22:\"session.client.browser\";s:74:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:13.0) Gecko/20100101 Firefox/13.0.1\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:78:\"/home/myserverdir/public_html/mysite/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:16:\"com_mailto.links\";a:2:{s:40:\"80de077c07eb27ff2d8530840432d70d637894f4\";O:8:\"stdClass\":2:{s:4:\"link\";s:162:\"http://www.mysite.com/index.php?option=com_content&view=article&id=73: -natural-body-care-by-native-american-wisdom&catid=25:the-project&Itemid=66\";s:6:\"expiry\";i:1342482146;}s:40:\"9a058fb095eb9d93c2c31f2a842a9f57178711d3\";O:8:\"stdClass\":2:{s:4:\"link\";s:114:\"http://www.mysite.com/index.php?option=com_content&view=article&id=74:about-us&catid=25:the-project&Itemid=67\";s:6:\"expiry\";i:1342482154;}}s:13:\"session.token\";s:32:\"5dd24fa339ade88efb9e4befcdbebf94\";s:17:\"application.queue\";a:2:{i:0;a:2:{s:7:\"message\";N;s:4:\"type\";s:7:\"message\";}i:1;a:2:{s:7:\"message\";s:16:\"E_NOLOGIN_ACCESS\";s:4:\"type\";s:5:\"error\";}}}auth|a:11:{s:11:\"show_prices\";i:1;s:7:\"user_id\";i:0;s:8:\"username\";s:4:\"demo\";s:5:\"perms\";s:0:\"\";s:10:\"first_name\";s:5:\"guest\";s:9:\"last_name\";s:0:\"\";s:16:\"shopper_group_id\";s:1:\"5\";s:22:\"shopper_group_discount\";s:4:\"0.00\";s:24:\"show_price_including_tax\";s:1:\"1\";s:21:\"default_shopper_group\";i:1;s:22:\"is_registered_customer\";b:0;}cart|a:1:{s:3:\"idx\";i:0;}recent|a:1:{s:3:\"idx\";i:0;}ps_vendor_id|i:1;minimum_pov|s:4:\"6.00\";vendor_currency|s:3:\"USD\";vmUseGreyBox|s:1:\"0\";vmCartDirection|s:1:\"0\";vmMiniCart|b:0;'
WHERE session_id='e10592a543ebeb836cc7c5a95e0424a8'
5. SELECT *
FROM jos_components
WHERE parent = 0
6. SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
7. CREATE TABLE IF NOT EXISTS `jos_ualog` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`user_id` INT(11) NOT NULL,
`option` VARCHAR(255) NOT NULL,
`task` VARCHAR(255) NOT NULL,
`action_link` text NOT NULL,
`action_title` text NOT NULL,
`item_title` VARCHAR(255) NOT NULL,
`cdate` INT(11) NOT NULL,
PRIMARY KEY (`id`))
8. SELECT id, parent_id, VALUE, name, lft, rgt
FROM jos_core_acl_aro_groups
WHERE id=23
9. SELECT name,player_id,ripper_id,postreplace
FROM jos_avr_tags
10. SELECT name,player_id,ripper_id,postreplace
FROM jos_avr_tags
11. SELECT id, gid
FROM jos_users
WHERE username='Myusername'
12. SELECT `id`, `password`, `gid`
FROM `jos_users`
WHERE username='Myusername'
13. SELECT *
FROM jos_users
WHERE id = '42'
14. DELETE
FROM jos_session
WHERE ( TIME < '1342481268' )
15. SELECT *
FROM jos_session
WHERE session_id = '6c9c6f3b6138544ac97616fe868a42fd'
16. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '6c9c6f3b6138544ac97616fe868a42fd','1342482168','','0','1','0' )
17. SELECT id
FROM jos_users
WHERE username = 'Myusername'
LIMIT 0, 1
18. SELECT *
FROM jos_users
WHERE id = '42'
19. SELECT g.*
FROM jos_core_acl_aro_groups AS g
INNER JOIN jos_core_acl_groups_aro_map AS gm
ON gm.group_id = g.id
INNER JOIN jos_core_acl_aro AS ao
ON ao.id = gm.aro_id
WHERE ao.VALUE='42'
ORDER BY g.id
20. SELECT COUNT(*)
FROM jos_core_acl_aro_groups AS g1
LEFT JOIN jos_core_acl_aro_groups AS g2
ON (g1.lft > g2.lft
AND g1.lft < g2.rgt)
WHERE g1.name = ''
AND g2.id = 0
21. SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
22. SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 66)
ORDER BY menuid DESC
LIMIT 0, 1
23. SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS SECTION, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = cc.SECTION
AND s.scope = "content"
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE a.id = 73
AND ( ( a.created_by = 0 ) OR ( a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-07-16 23:42:48' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-07-16 23:42:48' ) ) OR ( a.state = -1 ) )
24. UPDATE jos_content
SET hits = ( hits + 1 )
WHERE id='73'
25. SELECT g.*
FROM jos_core_acl_aro_groups AS g
INNER JOIN jos_core_acl_groups_aro_map AS gm
ON gm.group_id = g.id
INNER JOIN jos_core_acl_aro AS ao
ON ao.id = gm.aro_id
WHERE ao.VALUE='62'
ORDER BY g.id
26. SELECT id, title, module, POSITION, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 66 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
27. SELECT group_id,group_name,group_level
FROM `jos_vm_auth_group`
ORDER BY group_level
28. SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
FROM `jos_vm_shopper_group`
WHERE jos_vm_shopper_group.vendor_id='1'
AND `default`='1'
29. SELECT `name`
FROM `jos_core_acl_aro_groups`
WHERE `id` =29
30. SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
FROM (`jos_vm_vendor` v, `jos_vm_country` c)
LEFT JOIN jos_vm_state s
ON (v.vendor_state=s.state_2_code
AND s.country_id=c.country_id)
WHERE `v`.`vendor_id`=1
AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
31. SELECT id, params
FROM jos_menu
WHERE link='index.php?option=com_virtuemart'
AND published=1
32. SELECT id
FROM jos_menu
WHERE link='index.php?option=com_virtuemart'
AND published=1
33. SELECT category_id, category_description, category_name,category_child_id AS cid, category_parent_id AS pid,list_order, category_publish
FROM jos_vm_category, jos_vm_category_xref
WHERE jos_vm_category.category_publish='Y'
AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
ORDER BY jos_vm_category.list_order ASC, jos_vm_category.category_name ASC
34. SELECT group_id,group_name,group_level
FROM `jos_vm_auth_group`
ORDER BY group_level
35. SELECT published
FROM jos_modules
WHERE module='mod_virtuemart_cart'
36. SELECT m.*
FROM jos_menu AS m
WHERE menutype='topmenu'
AND published = 1
AND access <= 0
ORDER BY ordering
37. SELECT catid
FROM jos_content
WHERE id = 73
4 legacy queries logged
1. SELECT `lft`, `rgt`
FROM `jos_core_acl_aro_groups`
WHERE `name`='Public Frontend'
2. SELECT g1.id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2
ON g1.lft BETWEEN g2.lft
AND g2.rgt
WHERE g1.lft BETWEEN 3
AND 12
GROUP BY g1.name
ORDER BY g1.lft
3. SELECT `lft`, `rgt`
FROM `jos_core_acl_aro_groups`
WHERE `name`='Public Backend'
4. SELECT g1.id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2
ON g1.lft BETWEEN g2.lft
AND g2.rgt
WHERE g1.lft BETWEEN 13
AND 20
GROUP BY g1.name
ORDER BY g1.lft
Language Files Loaded
• /home/myserverdir/public_html/mysite/language/en-GB/en-GB.ini 1
• /home/myserverdir/public_html/mysite/administrator/language/en-GB/en-GB.plg_system_modulesanywhere.ini 1
• /home/myserverdir/public_html/mysite/administrator/language/en-GB/en-GB.plg_content_avreloaded.ini 1
• /home/myserverdir/public_html/mysite/language/en-GB/en-GB.plg_system_debug.ini 1
• /home/myserverdir/public_html/mysite/language/en-GB/en-GB.com_content.ini 1
• /home/myserverdir/public_html/mysite/language/en-GB/en-GB.plg_content_pagebreak.ini 1
• /home/myserverdir/public_html/mysite/language/en-GB/en-GB.tpl_natura_plazza.ini
• /home/myserverdir/public_html/mysite/language/en-GB/en-GB.mod_mainmenu.ini 1
• /home/myserverdir/public_html/mysite/language/en-GB/en-GB.mod_virtuemart_cart.ini
• /home/myserverdir/public_html/mysite/language/en-GB/en-GB.mod_virtuemart.ini
• /home/myserverdir/public_html/mysite/language/en-GB/en-GB.mod_virtuemart_login.ini
• /home/myserverdir/public_html/mysite/language/en-GB/en-GB.mod_mailchimp.ini 1
• /home/myserverdir/public_html/mysite/language/en-GB/en-GB.mod_smoothgallery.ini 1
• /home/myserverdir/public_html/mysite/language/en-GB/en-GB.mod_exmenu-j15.ini
Untranslated Strings Diagnostic
None
Untranslated Strings Designer
None
thefaro wrote:OK guys, I think I found the solution for everyone's issue here in this thread. I have just fixed my database. Follow these simple steps and everything should be back to normal.
Note: You must have your users in the jos_users table in order to fix the issue. If you have lost your users entirely within the (jos_users table) SQL, this will not help you.
Step 1 - Back up the following SQL tables:
jos_users
jos_core_acl_aro
jos_core_acl_aro_groups
jos_core_acl_aro_map
jos_core_acl_aro_sections
jos_core_acl_groups_aro_map
Step 2 - Delete each row in the jos_core_acl_aro table. Do so by scrolling below all of the rows displayed and clicking "Check All" and then the "X" button.
Step 3 - Run the following SQL code in your database by copying/pasting the code in the SQL tab.All of your users from jos_users should now appear in the jos_core_acl_aro table.Per Yngve Berg wrote:Code: Select all
insert into jos_core_acl_aro (section_value, value, name) select 'users', id, name from jos_users;
Step 4 - Delete each row in the jos_core_acl_groups_aro_map table. Do so by scrolling below all of the rows displayed and clicking "Check All" and then the "X" button.
Step 5 - Run the following SQL code in your database by copying/pasting the code in the SQL tab.
All of your users from the jos_core_acl_aro table should be synced with the jos_core_acl_groups_aro_map table.Per Yngve Berg wrote:Code: Select all
insert into jos_core_acl_groups_aro_map (group_id, aro_id) select '18', id from jos_core_acl_aro;
Step 6 - Cry tears of joy.
Now, to grant rights to those who need them, simply access the jos_core_acl_aro_groups table. Take note of the id column. That is the number you will be replacing some group ids with in the jos_core_acl_aro_groups table. Make certain to change the correct user. The aro_id is the same as the id listed in the jos_core_acl_aro table.
Hope this helps a ton (^__^). I know I feel relieved that this nightmare is over for meh.