Hello, we're currently performing maintenance on our site. Some functionality might be limited during this time.


Debug = hide_meta =
Debug SQL = SELECT post_id, post_content, post_title, REPLACE(um__key, ',', ' | ') AS um__key, REPLACE(REPLACE(um__value, ',', ' | '), ' - ', ',') AS um__value FROM ( SELECT post_id, post_content, post_title, GROUP_CONCAT(um__key) AS um__key, GROUP_CONCAT(um__value) AS um__value FROM data_posts dp LEFT JOIN ( SELECT um.database_id AS um__dbID, um.key AS um__key, REPLACE(um.value, ',', ' - ') AS um__value FROM users_meta um WHERE 1 = 1 AND um.database = 'data_posts' ) um ON um__dbID = dp.post_id WHERE dp.data_type = 98 AND dp.post_title != '' GROUP BY um__dbID ) tbl_src Values before replace = myform | class | 2 | 5 | 0 | 1,15,88,89 | Listing|users_data|1,Member Article|data_posts|15,Event|data_posts|8,Job Listing|data_posts|9,Coupon|data_posts|7,Video|data_posts|13,Audio File|data_posts|5,Blog Article|data_posts|14,Sweepstake|data_posts|70,News|data_posts|71,Glendale City Event|data_posts|72,Member Event|data_posts|73,Classified|users_portfolio_groups|6,Photo Album|users_portfolio_groups|10,Property|users_portfolio_groups|12,Product|users_portfolio_groups|11,Main Category|list_professions|88,Sub Category|list_services|89 | ,,,,,,,,,,,,,,,,, | 2,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,2,2 | 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1 | 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1 | 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1 | 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0 | 0,1,1,1,1,1,1,1,1,1,1,1,1,1 - Values after replace = myform | class | 2 | 5 | 0 | 1,15,88,89 | Listing|users_data|1,Member Article|data_posts|15,Event|data_posts|8,Job Listing|data_posts|9,Coupon|data_posts|7,Video|data_posts|13,Audio File|data_posts|5,Blog Article|data_posts|14,Sweepstake|data_posts|70,News|data_posts|71,Glendale City Event|data_posts|72,Member Event|data_posts|73,Classified|users_portfolio_groups|6,Photo Album|users_portfolio_groups|10,Property|users_portfolio_groups|12,Product|users_portfolio_groups|11,Main Category|list_professions|88,Sub Category|list_services|89 | ,,,,,,,,,,,,,,,,, | 2,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,2,2 | 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1 | 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1 | 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1 | 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0 | 0,1,1,1,1,1,1,1,1,1,1,1,1,1 -
Keys = Array ( [0] => form [1] => au_selector [2] => au_length [3] => au_ttlimit [4] => au_hint [5] => au_module [6] => au_main_info [7] => auHeaderTitle [8] => au_limit [9] => au_header [10] => au_photo [11] => au_location [12] => au_link [13] => au_comesf [14] => website_id [15] => form_name [16] => myid [17] => method [18] => noheader [19] => id [20] => save )
Values = Array ( [0] => myform [1] => class [2] => 2 [3] => 5 [4] => 0 [5] => 1,15,88,89 [6] => Listing|users_data|1,Member Article|data_posts|15,Event|data_posts|8,Job Listing|data_posts|9,Coupon|data_posts|7,Video|data_posts|13,Audio File|data_posts|5,Blog Article|data_posts|14,Sweepstake|data_posts|70,News|data_posts|71,Glendale City Event|data_posts|72,Member Event|data_posts|73,Classified|users_portfolio_groups|6,Photo Album|users_portfolio_groups|10,Property|users_portfolio_groups|12,Product|users_portfolio_groups|11,Main Category|list_professions|88,Sub Category|list_services|89 [7] => ,,,,,,,,,,,,,,,,, [8] => 2,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,2,2 [9] => 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1 [10] => 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1 [11] => 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1 [12] => 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0 [13] => 0,1,1,1,1,1,1,1,1,1,1,1,1,1 - )
Wrong data found, num of keys (21) and num of values (14) do not match on Users Meta table.
Debug...