Stack Overflow
Stack Overflow

Questions tagged [dbforge]

dbForge is a Database Version Control Software by DevArt. It helps commit, pull, push, compare your database schemas through a user friendly GUI.

54 questions
9
votes
2 answers

Create Unique field in Codeigniter DBForge Migration

How can I make the financial_year field as unique using Codeigniter Dbforge migration? function up() { $this->dbforge->add_field(array( 'id' => array( 'type' => 'INT', 'constraint' => …
Anshad Vattapoyil
  • 23,145
  • 18
  • 84
  • 132
8
votes
1 answer

Codeigniter creating an ENUM field with dbforge

I create a ENUM field, here is my code: $field['test'] = array( 'type' => 'ENUM', 'constraint' => array('a','b','c'), 'default'=> "a" ); $this->dbforge->add_field($field); $this->dbforge->create_table('demo'); And I got a message: Error…
Joshua Hansen
  • 405
  • 1
  • 8
  • 21
4
votes
2 answers

SQL command line error

I was trying to add a table to a database in MySQL using the command line: mysql -u Jon -p testdb --password=password < "C:\Users\Jon\Documents\Summer\Do\SQL\root.sql" However, I get an error when I type the above: ERROR 1064 (42000) at line 12:…
Max Kim
  • 1,114
  • 6
  • 15
  • 28
2
votes
2 answers

MySQL Continue Error Handler for missing table when calling PREPARE

In my stored procedure I am calling PREPARE for multiple INSERT IGNORE INTO statements from one database to another, but there is a chance that they dont have the same tables. So all I want to do is to skip that SQL statement and continue to next…
q1werty
  • 51
  • 6
2
votes
1 answer

Codeigniter 3 multiple database connections with dbforge

I am building a web app with CI 3, I have to use 2 different database connections for certain requirement. I have loaded the configuration to the database.php file and I can of course connect to them using the built in classes. $db['default'] =…
Fawzan
  • 4,738
  • 8
  • 41
  • 85
2
votes
1 answer

Viewing MariaDB column_list result via DBForge

Using the example in provided by DBForge for COLUMN_LIST against the table assets, when I run the following: SELECT item_name, column_list(dynamic_cols) FROM assets; Through DBForge Studio, the resultset for column_list(dynamic_cols) is shown as an…
YCY
  • 21
  • 1
2
votes
0 answers

Codeigniter add_column not working as expected

I'm trying to add some extra columns to an existing table with the codeigniter dbforge way. I'm doing everything like this here. dbforge,add_column. It wasn't working with the migrations, but after i tried to put the exact same code into some of my…
rsz
  • 1,141
  • 1
  • 18
  • 38
2
votes
2 answers

CodeIgniter / dbForge - multiple keys

Im using CodeIgniters DBforge to use my database. Im trying to convert a plain PHP script to CodeIgniter and im having some trouble with changing the SQL to dbforge. I have the following SQL code CREATE TABLE `message2_recips` ( `mid` int(10)…
BigJobbies
  • 3,633
  • 11
  • 43
  • 66
1
vote
1 answer

Trouble using dbforge with PyroCMS (CI based CMS)

I have been using PyroCMS and CI for quite some time, and truly love it. I am extending a DB module that will allow an admin user to manage a DB without having to use something like phpMyAdmin. The only thing I have been able to get working however…
jiminikiz
  • 2,867
  • 1
  • 25
  • 28
1
vote
1 answer

MySQL User Can't View, Edit or Debug Stored Procedures (Amazon RDS)

I had some issues about the creation of new users for my MySQL RDS. The process was the following: CREATE USER 'james'@'%' IDENTIFIED BY 'AdminTest2022'; GRANT ALL PRIVILEGES ON testdatabase.* TO 'james'@'%'; FLUSH PRIVILEGES; So, connecting with…
Gutierrez
  • 157
  • 1
  • 14
1
vote
1 answer

Single MySQL Database Migration Between Amazon RDS With Same Specifications

Good day community, my issue with my database is the following: In my RDS A I have several databases but I'm only interested in migrate just one database, the biggest of them all (aprox 95GB). The database has around 700 tables, 3000 procedures…
Gutierrez
  • 157
  • 1
  • 14
1
vote
1 answer

MySQL roles don't work in a Delphi application

I am using MariaDB10 with DBForge and creating a Delphi Project, I created a role to manage the permissions but it's not working good. 1 - Create a role on DbForge panel with a permission for a procedure myprocedure 2 - Add a Tmyquery in my Delphi…
BDuarte
  • 129
  • 11
1
vote
4 answers

How I can add column before another column in dbforge?

I want to add column that name 'accept_loc', type 'VARCHAR' to 3 database tables (use dbforge library from codeigniter) Assum they are named t1,t2,t3. t1 structure: id bla_bla pick_up_loc .... t2 structure: id pick_up_loc .... t3…
test test
  • 53
  • 1
  • 9
1
vote
2 answers

Unexpected Symbol 'NONE' Archive Engine - MariaDB DBForge

I am trying to create an archive table in MariaDB using dbForge and I'm getting the following error when I save the table. Unexpected Symbol 'NONE' dbForge automatically changes the following line from: PRIMARY KEY…
SkelDave
  • 1,176
  • 2
  • 9
  • 23
1
vote
2 answers

access mysql database (mamp) in host from Windows guest (dbforge query builder)

I need to be able to access mysql database that I am running in the host through MAMP (not pro) from a program called dbforge query builder running in the windows host. I try to put the ip address of the host in the program but it returns an error:…
Chriz74
  • 1,410
  • 3
  • 23
  • 47
1
2 3 4