Hi Prause,
That’s bad news! Can you please tell me:
– Can you see the table wpda_sas_module in the Data Explorer?
– If so, does it contain any rows?
– Is the Modules menu visible in the WPDA SAS menu?
– If so, can you click on it?
– Is there any error message?
Hope I can help you…
Best regards,
Peter
Thread Starter
Josef
(@prause)
Hi Peter,
1. yes
2. it contains 8 rows: HTML For Dummies, HTML Advanced Topics, etc.
3. yes
4. can click on it
5. no error message, just ‘No data found’.
Hi Josef,
– Did you enter some text in the search box?
– Do you get any rows in the other menus?
Best regards,
Peter
Thread Starter
Josef
(@prause)
Hi Peter,
– don’t know which search box you mean
– the other menus i.e. Courses, Teachers, Students give the same – No data found. The tables are there and contain data.
Josef
Is you navigate to table wpda_sas_module in the Data Explorer, do you see any rows then Josef?
Thread Starter
Josef
(@prause)
Yes, as I said before, I can see 8 rows in wpda_sas_module.
Hi Josef,
Strange! But I might have an idea…
I patches version 2.0.12. Can you please delete the plugin and then reinstall it? Unfortunately you’ll have to import the demo again. Sorry for that! But I hope it will solve the problem.
When you import the demo again, you’ll get an error message as you already have the demo tables. You can ignore that error. Hope this works…
Best regards,
Peter
Thread Starter
Josef
(@prause)
When I set debug to true in wp-config.php, then in Data Explorer I get for each table an error like this:
“!WordPress database error: [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 ‘-data-access.wpda_sas_module’ at line 2]
select count(*) from wp-data-access.wpda_sas_module”
Looks like the plugin is searching for table wpda_sas_module in database wp-data-access. As far as I know a mysql database name cannot contain the minus character.
What is the name of your WordPress database?
Hi Josef,
I thought wp-data-access would not be a valid database name. You can however create a database with that name as long as you put the name between backticks. The plugin is not handling these database names correctly!
I will fix this issue as soon as possible. If you want to have a look at the demo app, you can rename the database to something like wpdataaccess. That should work.
Sorry for the inconvenience. But thanks for pointing out this issue! You’re helping to improve the stability of the plugin.
Best regards,
Peter
Thread Starter
Josef
(@prause)
Peter,
the name of my database was ‘wp-data-access’. After renaming it to ‘wpdataaccess’ my issue is cleared.
BTW, I have a few WordPress databases having minus character in their names and never had any issue with this.
Josef
Hi Josef,
Good to hear it works! 🙂 Now you can at least have a look at the demo app.
I don’t think the minus character is an issue. It’s just not handled correctly by the plugin. My responsibility of course! I’ll take care of it.
Thanks again for pointing out this issue. I’ll leave the topic open untill the issue is solved.
Best regards,
Peter
Thread Starter
Josef
(@prause)
Thank you for your help.
Best regards, Josef
Hi Josef,
Been working on this topic overnight to solve it… 🙂 You should now be able to work with database names containing special characters. The plugin wasn’t handling these characters correctly for table and columns names as well, which I solved as well.
I’ll close this topic. Thank you for your patience!
Best regards,
Peter
Thread Starter
Josef
(@prause)
Hi Peter,
I confirm now it works with my database named ‘wp-data-access’.
Best regards,
Josef
