794 comments found.
Gilles, I am working off my hosted production site now. I don’t have access to some of the php configuration without going through Dreamhost Support. I did make some of the changes you suggested in terms of memory and I’m not getting the sluggish response times any longer and I am able to select the tables that I want to create a reading list from. I’m now getting a 500 error which is Server Internal Error So I have a couple of questions: 1. I don’t see an overall Dashboard. I would have thought that using w5obm/admin would display the Dashboard. In order to get anything, I have to use w5obm/admin/members (which is the table that I created the reading list from. 2. I then tried to create a Form using this same table It appears to have been created but when clicking on the message at the top to go to the Admin page, I get the Server error. Something isn’t setup correctly. 3. I want to allow several users to modify sections of this table but do not want all to edit some the payment data, or membership status data. I have not as yet created the Authoritative Module. Instructions said to create that last. How do I use the Membership table but limit the form to say 10 rows that can be modified . Ultimately, I want to setup users, permissions and a login to limit access to these editable pages. Any help would be appreciated.
Hi Robert,
- You have first to turn display errors On in your php configuration to find why you have these Internal Server Errors. Alternatively you can find the errors messages in your server logs. These errors can be caused by many things: php version, a php extension missing, ...
- Same solution as #1
- Open
admin\secure\class\secure\Secure.phpand look at the comments in the code. You’ll find some code examples that you can copy/paste into the form to allow/disallow different parts of it depending on the user. Alternatively you also can test the$_SESSION['secure_user_profiles_name']variable, which is the profile name of the connected user and allow/disallow parts of your form accordingly.
I just installed this product on my production server which is hosted by Dreamhost.con. I can access the Generator.php file to begin creating a read list for the Admin console. However, and here is my problem, the table list will not let me select any table in my database except the first one that defaults in the selection field. I see the tables in its dropdown list but the code will not let me select it. Therefore, I can only create a read-list for that one table. One additional thought which might shed some light on this, I am getting extremely slow response when I move from one menu tab item to the other and when I try a drop-down selection, it takes several seconds to highlight the selection where the cursor is. Extreme slow response!!! Any thoughts on this? Robert
Hi Robert,
First of all, you should activate error display in your PHP configuration so that you get an error message when a load fails.
If you have tables with a lot of fields, it’s likely that your server is running out of memory, which is causing loading times to be too long. In this case, you need to adjust the PHP parameters in your server manager or php.ini.
Another solution is to use the generator locally, which would provide sufficient resources.
Gilles
How can I contact you about custom work with dashboard?
Hi, installed on subfolder, did htacess edit. Still going through documentation and doing the first implementations but stumbled on some errors:
ErrorString: include_once(inc/protect.php): Failed to open stream: No such file or directory
ErrorFile: /REDACTED/generator/inc/tabs-contents/diff-files-form.php
ErrorLine: 16
ErrorString: include_once(inc/protect.php): Failed to open stream: No such file or directory
ErrorFile: /REDACTED/generator/inc/tabs-contents/configuration-form.php
ErrorLine: 19
quickfix:
changed include_once ‘inc/protect.php’; to include_once ’../protect.php’;
Hi,
Thanks for purchase and for reporting this error.
I edited my source file, the cleanest way is to give the absolute path to avoid any trouble in both root & subfolder installation:
// in generator/inc/tabs-contents/diff-files-form.php from L.14
// lock access on production server
if (ENVIRONMENT !== 'localhost' && GENERATOR_LOCKED === true) {
include_once GENERATOR_DIR . 'inc/tabs-contents/diff-files-form.php';
}
If you need anything else you’re welcome,
Gilles
Hi Gilles, that’s indeed safer, thanks.
Thanks to you
Hi Gilles,
I’m having a difficulty with ajax on an advanced filter, not sure if you can help.
My filter works with ajax off, but when I turn ajax it doesn’t work, the search ajax request comes with no results and so the filter select stays empty.
I sent you the url details through the phpcrudgenerator.com chat, and would appreciate if you could please look and see if I’m doing something wrong on the table Messages filter.
Thank you
Hi,
I just answered your message and I’m waining now for your email
I can’t install your software on my server, I’ve uploaded all the files, when I go to the installation page, it freezes and doesn’t proceed from the first step. How can I do?
Hi Kris,
Thanks for purchase.
The first thing to do is to turn display_errors On in your php.ini If there’s a PHP error you’ll see the detail of the error displayed on the page.
If you want you can email me your FTP access with others details (installation URL, database credentials, purchase code from Codecanyon) then I’ll be able to help you efficiently.
Gilles
Hi fixed thankyou
Thanks to you,
If you need anything else you’re welcome,
Gilles
Hi,
im getting internal server error right after step 2. ive tested connection to database successfully.
entered my email and purchase code.
when click next. there was Internal server error.
Try again. same thing.
Please advice
Thank you
Kind regards
Robert
Hi Robert,
Thanks for purchase.
Please turn display_errors On in your php.ini then retry, the page will show the details of the error and it’ll help me to guide you.
Gilles
Hi Gilles
Fatal error: Uncaught Error: Call to undefined function ctype_alnum() in /hermes/bosnacweb08/bosnacweb08bd/b219/dom.connexbn38379/public_html/titandb/class/phpformbuilder/Validator/Token.php:424 Stack trace: #0 /hermes/bosnacweb08/bosnacweb08bd/b219/dom.connexbn38379/public_html/titandb/class/phpformbuilder/Validator/Token.php(717): aplCheckSettings() #1 /hermes/bosnacweb08/bosnacweb08bd/b219/dom.connexbn38379/public_html/titandb/install/do-install.php(177): installToken(‘https://titangu...', ‘robisq@gmail.co...’, ‘56cc4596-3eb9-4…’, Object(PDO)) #2 /hermes/bosnacweb08/bosnacweb08bd/b219/dom.connexbn38379/public_html/titandb/install/do-install.php(623): registerDbInfo() #3 {main} thrown in /hermes/bosnacweb08/bosnacweb08bd/b219/dom.connexbn38379/public_html/titandb/class/phpformbuilder/Validator/Token.php on line 424
this is the error its showing after turning on display_error
Thanks for your feedback.
The ctype_alnum function is available in all PHP versions since PHP 4 – https://www.php.net/manual/en/function.ctype-alnum.php -, and is installed and enabled by default – https://www.php.net/manual/en/ctype.installation.php
So you have to contact your hosting service and ask them to enable it. There’s no reason to disable this PHP native function and it should be available in any PHP installation.
If you need anything else you’re welcome,
Gilles
Thank you for the advice.
Installation was successful. After clicking on OPEN THE CRUD GENERATOR NOW, it was brought to the admin panel, but the page head is showing this.
Notice: Undefined offset: 0 in /hermes/bosnacweb08/bosnacweb08bd/b219/dom.connexbn38379/public_html/titandb/generator/class/generator/Generator.php on line 403
Notice: Undefined offset: 0 in /hermes/bosnacweb08/bosnacweb08bd/b219/dom.connexbn38379/public_html/titandb/generator/class/generator/Generator.php on line 404
Notice: Undefined offset: 0 in /hermes/bosnacweb08/bosnacweb08bd/b219/dom.connexbn38379/public_html/titandb/generator/class/generator/Generator.php on line 405
This is because your database has no table. If you add a table the messages will be gone.
I added this case management to show a nice message instead of these dirty PHP NOTICE in my TODO list.
How can we activate the PHP CRUD Generator for a development domain and a live domain? I have finished my work today and I have copied to the live server. Not it says it says the license is not correct. So I activate it again on the live server. But when I want to make changes on the dev server I can’t because there the license is again not activated.
Hi,
Thanks for purchase.
Everything is explained here: https://www.phpcrudgenerator.com/tutorials/how-to-use-phpcg-on-a-localhost-and-a-remote-server
In short, you have to take care of 2 things:
- The
user_datatable contains the license information, which is different on local & production server, so it shouldn’t be copied from one server to the other -
class/phpformbuilder/database/db-connect.phpcontains the database connection information for both local & production servers. When you install it registers the information for the current active server. If you edit this file to enter the information for the 2 servers you can then keep it synchronized between both.
I hope it’s clear, If you need anything else you’re welcome,
Gilles
This doesn’t help me. When I do the install on the new production server, it says that the purchase code is not valid or used. Unregister is not possible. The dev server doesn’t has “localhost” as a domain. It has a real domain.
What does your local server return for $_SERVER['REMOTE_ADDR']?
If it’s properly configured it should return ‘127.0.0.1’ or ’::1’, no matter the URL you use.
If it returns something else you have to configure it to return one of the expected values, or alternatively you can edit conf/conf.php and add your value L.128:
if ($_SERVER['REMOTE_ADDR'] == '127.0.0.1' || $_SERVER['REMOTE_ADDR'] == '::1' || $_SERVER['REMOTE_ADDR'] == 'your-custom-value') {
I’m available on chat at https://www.phpcrudgenerator.com if you need.
Hello!! Thanks for this super useful script. I would to ask you if it’s possible to have a select option with values, and depending on the selection, another select with options to appear?
Thanks in advance!!!
Hi,
Thanks for purchase.
Yes it’s possible, you have to edit the code of your form in admin/inc/forms.
The forms are all made with PHP Form Builder ; you’ll find an example of dependent select dropdown here with the PHP code: https://www.phpformbuilder.pro/templates/bootstrap-5-forms/dependent-select-dropdown.php
If you need anything else you’re welcome,
Gilles
Hi, is forgot password system included? Thanks
Hi,
Not yet, it’s in my TODO list.
For the time being, if you forgot your generator or admin longi/password you can disable the authentication module in conf/user-conf.json in setting ‘generator_locked’ or ‘admin_locked’ to false.
If you need anything else you’re welcome,
Gilles
Thanks!
Bonjour,
Je me permet de vous parler en français car j’ai vu que vous étiez localisé en France.
J’ai acheté PHP Crud Generator le 8 Janvier et j’ai quelques dificultés dans l’installation. Est-il indispensable de l’installer dans le répertoire racine du site ?
Cela semble être correct car je vois mes tables mais rien ne se produit et je ne peux pas y accéder.
Merci de votre aide
Olivier
Bonjour Olivier,
Merci d’avoir acheté PHP CRUD Generator.
Je travaille justement sur la traduction du site et de la documentation, qui sont maintenant disponibles en Français. Il n’y a aucun inconvénient à installer depuis un sous-répertoire, il faut simplement modifier le .htaccess du dossier admin/ comme c’est expliqué ici: https://www.phpcrudgenerator.com/fr/documentation/index#installation-registration
Gilles
Hi – planning to use as on my domain under multiple sub domains – can i install on the sub domain and will licence work for multiple installs OR will it need to be on the main domain 1st before sub domains will work? Thanks
Hi,
Thanks for purchase.
You should install only from your main domain, then:
- Don’t run the installer on subdomains, but copy the package files on each
- If you use the same database, copy
class/phpformbuilder/database/db-connect.phpfrom your main domain to your subdomains - else, for each subdomain:
- enter your connection settings manually in
class/phpformbuilder/database/db-connect.php - copy the
user_datatable generated by the installer in each database.
- enter your connection settings manually in
If you need anything else you’re welcome,
Gilles
Thanks is there any issues with MariaDB 10.4.32?
No known issue.
Thanks – im following your video on how to create the database – i synced it all fine as a test, and then added in relationships, but that always throws a 1064
A MySQL 1064 error might have different causes.
Googling “How to Fix the MySQL 1064 Error” can help. For now, I don’t know exactly what you’re doing and when the error occurs, so I can’t help you more.
pre buy question 1. can i use my database table and generate crud for each table. 2. do u provide code for chart integeration or display table contents in visualize manner.
Hi,
- Yes, you can, with PHP CRUD Generator will do it at a glance.
- The code to generate the statistics is not included in the package, but just ask me and I’ll send you a ZIP. The library used is Apex Charts. You need to send the query to your database to retrieve the data to be integrated, then set the parameters for the charts. I can help with that; in this case I’d need FTP access and possibly PHPMyAdmin access..
thanks, i would need the zip files, rest i’ll and if help required will contact u. will buy shortly
one more question, i was going thru the documentation. my database is already have table users now in your authentication module, users and user_profile tables are created. so how to deal with this.
The authentication module uses “users” and “users_profiles” tables with a prefix. You can set the prefix as desired.
If you want to restrict access to some data for users (i.e. the user can only see his own records) you can add a relationship between your users table and phpcg_users.
already sent email plz send details
Hi,
I think I didn’t receive your email (or did I already answered without knowing who you are?) and I have no idea about what your question is.
Please tell me how I can help,
Gilles
i send msg here https://www.miglisoft.com/#contact along with my purchase code… resending email again plz send files and instructions for charts integerations. thanks
Indeed I already answered you and sent you a zip but it seems the email has been filtered, probably for security reasons. I just sent you the zip again.
Hello, I host the script on a commercial hosting company’s server (shared hosting) in the backend of my website. When I run the install it asks to change the server settings. I am not able to change apache server settings. Can you clarify the first step in the installation “The FollowSymLinks option is not allowed in your Apache server configuration.”? Can this be solved with some local .htaccess file in the script installation itself?
Hi,
The message gives you the lonk to the documentation, which gives you the solution with .htaccess:
https://www.phpcrudgenerator.com/help-center#followsymlinks-not-allowedPlease try it and let me know if you still have any problem,
Gilles
I did it. In the .htaccess file in the /admin/ folder, the # sign was added in the second line and I changed the path to the subfolder in the 18th line. I can’t run ../install/do-install.php (The FollowSymLinks option is not allowed in your Apache server configuration.)
The problem is related to your server configuration. Could you please email me your FTP access and installation URL?
Sent
Thanks. I just answered you, it’s solved now (the problem was caused by a .htaccess in your admin/assets/ folder, probably generated by your server for some unknown reason).
Good Day I have a question regarding on PHP CRUD Generator.
1.Can I edit the logo of the dashboard? 2.Can I edit the navigation menu to Top bar? 3.Can I edit the login design? 4.Can I assign user roles, like Admin, Editor and default user only?
Hi Mark,
Everything is always possible, the question is: is it easy or not.
- You can choose your logo in the Generator’s configuration tab. You can’t see it in the demo because I disabled it, but in real life an image uploader is available.
- If you want to move the left navigation to the top I’d rather say no you can’t,it’ll not be easy at all. But if you want to add a custom navigation on top yes it’s possible. I can help if you send me your FTP access.
- Yes, you can edit the login page design easily. It’s a simple php file with HTML. The form is designed with PHP Form Builder.
- Users & profiles are managed with the help of the authentication module. PHP CRUD Generator is very powerful for this. Everything is explained here: https://www.phpcrudgenerator.com/tutorials/user-profiles-and-rights
If you need anything else you’re welcome,
Gilles
Hi. Unfortunately I’m not able to get rid of the error: “The FollowSymLinks option is not allowed in your Apache server configuration.” although I’ve followed tehe recommendation to modify .htacces. To have any further tip for me? Thanks.
Hi,
The solution is explained here: https://www.phpcrudgenerator.com/help-center#error-404 (solution #3)
This is an Apache setting, you have to edit your Apache configuration file (httpd.conf), not the .htaccess.
You’ll find others detailed explanations if you search “apache followsymlinks” in your browser search.
You also can ask hyour server provider for help if you’re on a remote server.
If you need anything else you’re welcome,
Gilles
Hi, is there any option to upload multiple files at once? I don’t see it in version 1, I hope version 2 has it.
Hi,
You can set this up by editing the appropriate form in admin/inc/forms/, but this is not a built-in feature, and there’s a reason for this:
If you upload several images and save them in a single field, editing them becomes very complicated. For example, if you then want to replace the second one and add another, the program can’t guess which image to replace the one that’s been deleted with.
The documentation for editing a form is here: https://www.phpcrudgenerator.com/tutorials/how-to-customize-the-bootstrap-admin-forms
I had a text connection verified when I installed on my site but i would not go further in the steps. I cannot add the screenshot here Contact me at nat.mistry@gmail.com please
Hi!, I’ve detected some few bugs in your software:
1. In some headers it writes “|raw”, but I dont know why. Here you have a screenshot: https://tinyurl.com/yrtxvb8n
2. There is a bug escaping quotes in the “help text” (tooltip does it well): https://tinyurl.com/ymy7jdnc3. There is an issue with the translation. Specifically with string “define(‘NAME’, ‘…’)”, because it is used in at least two different scenarios with different meaning. First time I saw it was at the crud generator > read lists > add/edit values > custom values. Here, we can set names and values. Everything seems to be right. But then, it is used again at the authentication module, asking for the “last name”.
Originally, your “es.php” was set this way: “define(‘NAME’, ‘Apellidos’);”. “Apellido” mean “last name” in spanish, so it is only correct in the authentication module, but not setting custom values, as you can imagine (It would be: “last name / value”).
So, the correct translation to that string is: “define(‘NAME’, ‘Name’);”, and it can’t be used int the authentication module.
I hope I explained myself well, sorry for my english.
4. There are some there are some incorrect translations, like: “define(‘ALL_RECORDS’, ‘Todas las grabaciones’);”, it must be: “define(‘ALL_RECORDS’, ‘Todos los registros’);”. Can I submit these corrections to you in any way so they will be fixed in future versions?
5. Then, there are a lot of untranslated strings, specially the crud generator, that I don’t know how to translate. Can you show me how can I do that?
That’s all. Thank you very much in advance.
Hi Marianogi,
Thanks for your useful comment. I worked and think (hope!) everything you pointed is solved.
I just published the new version 2.3.5 on Codecanyon, and the auto-updater.
Please do the following:
- Delete
generator/update/cache/update-versions.php.cacheon your server - Open the generator in your browser
- You’ll see the “new version available” button, click it to update.
Then:
- Rebuild your lists you need to get rid of the ”|raw” issue
- Rebuild the forms where you have the help text quote escaping issue
- The “NAME” translation is fixed (I moved the “last name ” to a new “LAST_NAME” constant. If you have some others corrections to improve the Spanish translations you can make the changes in admin/i18n/es.php. If you send me your file I’ll make the same changes for future updates.
If you need anything else you’re welcome,
Gilles
Wow!, you were extremely fast!, thank you!
I had another issue: the “update-alert” div remained with opacity near zero, so I could not see it. I know it was there because it appears a few miliseconds, enough to see it (and I update the software before).
The issue escaping quotes remains the same, sorry. It works ok with tooltips, but not with “help text”.
I’d like to know if you it has a way to translate strings or at least modify some already traslated strings that are not precise.
Thanks!
I have another question: Can I change the home page after login. I mean the page that starts with: “This admin panel uses a MySQL….”. I prefer to redirect it to any other url. Is that possible? That long english text is not very friendly to the spanish users. thank you.
Hi,
I don’t know what happened with the update but never had any complaint about it and for me it works fine. Maybe something coming from your browser, a temporary slow down or something.
About the quotes: I double-checked and it works for me, here’s an example: https://www.phpcrudgenerator.com/admin/rental/edit/rental_id=11739
To change the admin redirect page after login, open conf/conf.php and change the ADMINREDIRECTPAGE value L.55
You can also edit the admin’s home page template (the long text is just a demo, you can replace it as desired): /admin/templates/home.html
If you need anything else you’re welcome,
Gilles
Sorry but the escaping quotes does not work for me. What should I try? Can I check any file to check the code? (I am a programmer, too). Could it be an update issue?
And please, let me know if I can translate other strings.
My mistake, I made the change in the EDIT forms but forgot to make it in the CREATE forms.
The code to generate the help texts in the EDIT forms is in generator\generator-templates\form-edit-template.php L.971
If you copy/paste the same code into generator\generator-templates\form-create-template.php L.670 it will be ok for both.
The code is:$form->addHelper('<?php echo str_replace('\'', '\\\'', $help_text); ?>', '<?php echo $name; ?>', 'after');
About translations it depends on what you want to translate and where it’s located. If you give me more details I can tell you, and make the changes in my source files.
i am getting this error “License is not installed yet or corrupted.” all we did was upgrade from old hosted server to a new faster hosted server
Hi,
Please follow these instructions, it should solve your problem: https://www.phpcrudgenerator.com/help-center#license-is-not-installed-yet-or-corrupted
hello, what’s wrong with your demo? Errorcode”Database error 42000: Database Error (phpformbuilder\database\DB::query):”. The error occurs in the detail view of a data set.
Hello,
Thanks for reporting. This problem occured only in the demo (not in the Codecanyon package). I solved it.
