Hi all - I am upgrading from 2018 to 2023 - I am running on newest version of Xampp.When I add an entry to a table, dynamic lookup fields aren’t populating - for a dropdown it states "The results could not be loaded."I’m wondering if there is a problem with javascript on my xampp installation?
Note that Lookup permission was introduced in v2020, read notes under User Level. Fix the lookup permissions of your project and try again.
Thank you so much - I added those privileges, but still no luckTurned on debug mode, looks like the sql is executing properly - see below…Any other thoughts? Thanks for your help!Debug
sql: SELECT * FROM ptinfo WHERE login = ‘elaz’, executionMS: 0.0010919570922852sql: SELECT t0.id AS id_1, t0.login AS login_2, t0.password AS password_3, t0.UserLevel AS UserLevel_4, t0.activated AS activated_5, t0.email AS email_6, t0.Profile AS Profile_7, t0.dt_add AS dt_add_8 FROM ptinfo t0 WHERE t0.login = ? LIMIT 1, params: Array ( [0] => elaz ) , types: Array ( [0] => string ) , executionMS: 0.00092411041259766sql: SELECT int_value FROM a_options WHERE type = ‘starttime’ ORDER BY int_value ASC LIMIT 1, executionMS: 0.00070381164550781sql: SELECT int_value FROM a_options WHERE type = ‘starttime’ ORDER BY int_value DESC LIMIT 1, executionMS: 0.00022292137145996sql: SELECT displayname AS lf, displayname AS df, ‘’ AS df2, ‘’ AS df3, ‘’ AS df4 FROM staff_info_global WHERE 0=1 AND showonschedule = 1 ORDER BY displayname ASC, executionMS: 0.0002899169921875sql: SELECT name AS lf, name AS df, ‘’ AS df2, ‘’ AS df3, ‘’ AS df4 FROM a_service WHERE 0=1 AND name <> ‘Overbook’ AND name NOT LIKE ‘%Override%’ AND showinportal = 1 ORDER BY name ASC, executionMS: 0.0001978874206543sql: SELECT int_value AS lf, text_value AS df, ‘’ AS df2, ‘’ AS df3, ‘’ AS df4 FROM a_options WHERE int_value = 600 AND type = ‘starttime’ ORDER BY int_value ASC, executionMS: 0.00023889541625977sql: SELECT int_value AS lf, text_value AS df, ‘’ AS df2, ‘’ AS df3, ‘’ AS df4 FROM a_options WHERE int_value = 2030 AND type = ‘starttime’ ORDER BY int_value ASC, executionMS: 0.00014996528625488sql: SELECT name AS lf, name AS df, ‘’ AS df2, ‘’ AS df3, ‘’ AS df4 FROM locations WHERE name = ‘80111’ ORDER BY name ASC, executionMS: 9.3936920166016E-5sql: SELECT password FROM ptinfo WHERE login = ‘elaz’, executionMS: 0.00010514259338379sql: SELECT patientid FROM patient_list WHERE login = ‘elaz’, executionMS: 0.00017404556274414sql: SELECT color FROM a_service WHERE name = ‘’, executionMS: 0.00010895729064941
You may check HTTP response and check errors in the Network panel of your browser and in the log file on the server.