Databases
How to import/export a PostgreSQL database
Important: First you need to create a PostgreSQL database following this tutorial: https://help.scriptcase.net/portal/pt/kb/articles/banco-de-dados-postgresql 1 - In cPanel, access “phpPgAdmin”; To import: 2 - In the left panel of the screen, click ...
Creating a MySQL Database
The MySQL database allows you to store a lot of information with ease of access. Before using the database, first you must create one. Also, you need to create at least one MySQL user to access the database. Step 1 At your cPanel, in the "DATABASES" ...
How to connect to firebird database on hosting
In this example, we will show you how to connect the Firebird database. First you must access a database manager. Enter the information according to the image below. Host/Server: Your hosting domain. Path: the full path to the bank location, example: ...
How to create firebird database on your hosting
In this example, we will show the creation of a Firebird database. First you must access your cPanel: See how to obtain credentials and access cPanel through our article: ...
How to create and change the Firebird password
In this example, we will show you how to create and change the Firebird database password. First you must access your cPanel: See how to obtain credentials and access cPanel through our article: ...
How to upload a firebird database to your hosting acount
If you already have a Firebird database and want to host in our host account, just follow these steps: 1- Save/export your local firebird database with your cpanel username and password (the first one that was sent to your email) as the owner ...
Error "The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay"
This error occurs when the database needs to search on more than 1 million rows to meet he requirements of your query. This limitation does not concern the number of records in a table,but rather how many records will be read to satisfy a query, so ...
Import a CSV file to MYSQL via PHPMYADMIN
I was given access to an existing instance of MySQL via phpMyAdmin. My task was to import a CSV file using the import feature on phpMyAdmin. First, I went to the the main phpMyAdmin page. Next, I clicked on the database instance that I am interested. ...
How to access PhpMyAdmin in your hosting?
When hosting with Scriptcase the phpMyAdmin is already installed as standard, you just need to access it through cPanel. Through cpanel you go to "Database", then click on "phpMyAdmin", and you will be directed to the phpMyAdmin page. You will be ...
How to import a database in PhpMyAdmin?
To import your database into phpMyadmin, you must access phpMyadmin through cpanel. When you are in phpMyAdmin, you must choose a database into which the data will be imported (the empty database), which is located on the left, as shown in the ...
How to export your database in phpMyAdmin?
To export your database on phpMyadmin, you must access phpMyadmin through cPanel. - You must choose the database you want to export. - Click on the MySQL database you want to export, it is located on the left side, as shown in the following image: ...
How to create a VIEW in phpMyAdmin?
To create a View in phpMyadmin, you must first access phpMyadmin through cPanel. - Click on a table, it is located on the left side, as the following image: - Then you click on "View". - Then "Create View". - You will be presented with a form to ...
How to create Procedure in phpMyAdmin?
To create a Procedure in phpMyadmin, you must first access phpMyadmin through cPanel. - Click on your database which is located on the left side, after that, click on "Routines". - Then click on "Add Routine". - Fill in the data and parameters and ...
How to create a table in PhpMyAdmin?
To create a table in phpMyadmin, you must first access phpMyadmin through cPanel. - Click on the database you want to create the table, which is located on the left side; - Now click on "Create table", type the name of the table and the number of ...
How to change the charset of MySQL server
To change the MySQL charset, follow the steps below: 1. Access the phpMyAdmin option in the Database section of your cPanel 2. Check the current server charset 3. Go to Settings, select Features and then Database tab, change the server charset in ...
How to restore Firebird backup from the terminal?
To restore the backup of your Firebird database, you must first access the Terminal through the cpanel in "Advanced" and then click on "Terminal". Once you have the Terminal open, you will enter the following commands: gbak -user YOUR_USER -pas ...
Popular Articles
Fatal error: Array and string offset access syntax with curly braces is no longer supported
You can come across this error when running a login application created by a security module generated before Scriptcase 9.8. This error occurs only in an environment with PHP 8 or superior because of a change in the array elements access, that now ...
Setting password recovery in Scriptcase
To configure the password recovery, it's necessary to do some steps so that works correctly. To the recovery happens, will be necessary that you have and configure a SMTP server. After login, you'll access the menu Options > Settings > System ...
Necessary libraries to install the Scriptcase in Windows 7
To install Windows 7 SP1, you need to verify that the system has the following items installed: * Visual C ++ Redistributable Packages for Visual Studio (2008) x86 and x64. * Visual C ++ Redistributable Packages for Visual Studio (2010) x86 and x64. ...
How to perform a publication
A publication is the act of making external applications made to your project in the Scriptcase, so that they may be accessed by in the environment approval. Basically, the procedure is the last stage of development, where the user Scriptcase find ...
Using friendly URL
The friendly URL was included from Scriptcase 7, in order to make the URL, of the applications generated by Scriptcase, cleaner and easier to associate them with applications. For example, using friendly URLs the link to a Scriptcase application ...
Recent Articles
How to prevent your server's IP from ending up on a blacklist
To prevent your server's IP from being blacklisted, consider implementing the following best practices: 1. Keep Everything Updated: Ensure your software, and applications, is always up to date with the latest security patches. 2. Monitor for ...
How to import/export a PostgreSQL database
Important: First you need to create a PostgreSQL database following this tutorial: https://help.scriptcase.net/portal/pt/kb/articles/banco-de-dados-postgresql 1 - In cPanel, access “phpPgAdmin”; To import: 2 - In the left panel of the screen, click ...
Retrieve password
An inconsistency was observed when trying to reset the password using the "app_retrieve_pswd" application. The correction was made for new modules, created from release 9.10.001. For modules created in previous releases that use this option, we must ...
E-mail deliverability
Use este item para identificar problemas com seus registros DNS relacionados a e-mail de seus domínios. O sistema usa esses registros para verificar se outros servidores podem confiar nele como remetente. Passo 1- Para usar esta interface você ...
Offline Documentation
Starting with version 9.9.021, Scriptcase documentation is only available on our website, in two languages: English: https://www.scriptcase.net/docs/en_us/v9/manual/01-introduction/01-general-view/ Spanish: ...