Hi,

when trying to setup iScaffold with MSSQL I get an error when creating sf_config table.

The error massage says Wrong syntax in the near of 'sf_config'.

Falsche Syntax in der Nähe von 'sf_config'.

CREATE TABLE IF NOT EXISTS sf_config ( sf_id INT(5) UNSIGNED AUTO_INCREMENT PRIMARY KEY, sf_table VARCHAR(64) DEFAULT '' NOT NULL, sf_field VARCHAR(64) DEFAULT '' NOT NULL, sf_type VARCHAR(16) DEFAULT 'default' NULL, sf_related VARCHAR(100) DEFAULT '' NULL, sf_label VARCHAR(64) DEFAULT '' NULL, sf_desc TINYTEXT NULL, sf_order INT(3) NULL, sf_hidden INT(1) DEFAULT '0' NULL )

Filename: C:\www\iScaffold\system\database\DB_driver.php

Line Number: 330

My Environemnt:
Windows 2008 R2
PHP Version 5.2.17
Apache 2.2
DB: MSSQL 2005 express

Best regards
-Alex

Hi Tibor,

First of all, nice to see scaffolding for ci and i like the intro video. I didn't get a word from it :) but that's because i don't speak the language. Bulgarian here. :)

I get this error when i try to select database: (the db exist and it's specified in the database.php as well as the username)

The drop down is white and have some li's but each one of them is:

<a rel="&lt;?=$db?&gt;"><!--?=$db?--></a>

When i try to select something the open config button appears but when i click on it i get this:

A Database Error Occurred
Unable to select the specified database: %3C
Filename: D:\Repository\wamp\www\code\system\database\DB_driver.php
Line Number: 140

And btw i have the output folder writable but it doesn't show up as “The output directory is writable, have fun using iScaffold”

This is windows 7 with wamp. Any advice? BTW the database is empty but i also tried with a DB with tables and i get the same result.

root folder structure and config:

application
   config.php
       $config['base_url']  = 'http://localhost/code/';

   database.php
       $db['iscaffold']['hostname'] = 'localhost';
       $db['iscaffold']['username'] = 'root';
       $db['iscaffold']['password'] = '';
       $db['iscaffold']['database'] = 'code';

output - writable
repo
system
templates
index.php

Any help will be appreciated.

I would like to know how to select some tables .... ?¿ I want some tables are not displayed

Morning. Thanks again for all your efforts on this project. Looks great. I haven't had a chance to dig around to see what's going on, but the version I downloaded from here isn't writing changes to the sf_config table. Any thoughts?

The installation instructions are unclear.

For example, here is what I tried:

1. mkdir $HOME/htdocs
2. cd $HOME/htdocs
3. unzip ../software/codeigniter.zip
4. mv CodeIgniter_/_ .
5. rmdir CodeIgniter*
6. Edit application/config/config.php
7. Edit application/config/database.php
8. unzip ../software/iscaffold.zip
9. cp -R kowdermeister-iScaffold-b71dd49/* .
10. mkdir output
11. chmod 777 output
12. Browse to http://localhost/~user/

According to the installation instructions, I should have seen a big green line. Instead, I saw a blank page. Please update the installation instructions to show exactly how to install the software.

I download iscaffold..

edit database :

db['iscaffold']['hostname'] = 'localhost';
$db['iscaffold']['username'] = 'root';
$db['iscaffold']['password'] = '';
$db['iscaffold']['database'] = 'tesiscaffold'; // Just pick on of your database
// you can select later which you want to use
$db['iscaffold']['dbdriver'] = 'mysql';

Config :

$config['base_url'] = 'http://localhost/iscaffold/';

firts time i can view DB list .. so i change with following Kuporpal in last issue ( DB select Error )
"

list DB fixed ....

I choice tesiscaffold DB an click " Open configurator "

and warning agains :

Database table "sf_config" does not exists, click here to create it.

I click " click here to create it. "

and when i click it showing :

Forbidden

You don't have permission to access /iscaffold/< on this server.

some body please help.. sorry for my bad english

I want to make a N to 1 relationship for a ticket crud including tickets and many batches. I will use your crud generator to create me admin site but I want to know if the generator can make this or I have to set it up manually to include the batches in the same form.

Thanks.

i got this error but all the directory is correct...pls help me guys
Warning: require(/application/libraries/dotenv/src/Dotenv.php): failed to open stream: No such file or directory in C:\xampp\htdocs\iScaffold\index.php on line 9

Fatal error: require(): Failed opening required '/application/libraries/dotenv/src/Dotenv.php' (include_path='C:\xampp\php\PEAR') in C:\xampp\htdocs\iScaffold\index.php on line 9

Hi, when I tried to create an application with this tools, I receive this message

A PHP Error was encountered
Severity: Notice
Message: Undefined offset: 0
Filename: models/model_iscaffold.php
Line Number: 101

I found the line
$fields_id = $fields[0];
and I changed by this
$fields_id = count($fields) > 0 ? $fields[0]: '';

Hi

I have two databases the first is MariaDB it's works.

But when I try connect to MS SQL with sqlsrv driver or pdo_sqlsrv driver cannot connect.

Do you know something about that?

This is the error

Unable to connect to your database server using the provided settings.

Filename: C:\Users\np\Documents\Proyectos\crudIgniter\system\database\DB_driver.php

Line Number: 124

And this is my config

$active_group = 'iscaffold';
$active_record = TRUE;

$db['iscaffold']['hostname'] = $_ENV['DB_HOST'];
$db['iscaffold']['hostname'] = $_ENV['DB_HOST'];
$db['iscaffold']['username'] = $_ENV['DB_USER'];
$db['iscaffold']['password'] = $_ENV['DB_PASS'];
$db['iscaffold']['database'] = $_ENV['DB_NAME'];

$db['iscaffold']['dbdriver'] = 'sqlsrv';
$db['iscaffold']['dbprefix'] = '';
$db['iscaffold']['pconnect'] = TRUE;
$db['iscaffold']['db_debug'] = TRUE;
$db['iscaffold']['cache_on'] = FALSE;
$db['iscaffold']['cachedir'] = '';
$db['iscaffold']['char_set'] = 'utf8';
$db['iscaffold']['dbcollat'] = 'utf8_general_ci';
$db['iscaffold']['swap_pre'] = '';
$db['iscaffold']['autoinit'] = TRUE;
$db['iscaffold']['stricton'] = FALSE;

And the environment is IIS 10 php 7.0.2 for windows and the driver is php_sqlsrv_7_nts_x64.dll

Thank you
Cheers

Hi,
I followed all the steps but when I open iscaffold I have a blank page. I tried to install on Mac with MAMP, I activated 775 permissions for the file in question, but still does not work. I do not know what's wrong. Please help me if you can.

Thank you.