mantisbt:systemi
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
mantisbt:systemi [2007/02/07 00:31] – slashsplat | mantisbt:systemi [2011/12/14 14:54] (current) – The page rendering was broken (maybe since new PHP version on mantisbt.org). Added new line to fix it at end of file. atrol | ||
---|---|---|---|
Line 227: | Line 227: | ||
Issues of concern 2007-02-06 | Issues of concern 2007-02-06 | ||
- | ==== A. / | + | ==== A. install.php |
=== NOTE: / | === NOTE: / | ||
- | Install.php will not work. When run with the following parms (fields only in order): | + | / |
db2 (experimental)\\ | db2 (experimental)\\ | ||
Line 273: | Line 273: | ||
- | ==== B. / | + | ==== B. MD5 missing |
Enabled mcrypt/ | Enabled mcrypt/ | ||
Line 280: | Line 280: | ||
- | ==== C. / | + | ==== C. db2_tables error ==== |
- | ERROR: | + | |
+ | Install.php | ||
SYSTEM WARNING: db2_tables() expects parameter 1 to be resource, boolean given | SYSTEM WARNING: db2_tables() expects parameter 1 to be resource, boolean given | ||
comes from FILE: | comes from FILE: | ||
- | ./ | + | / |
function & | function & | ||
Line 296: | Line 297: | ||
I cannot figure this out and do not know if it affects issue A. | I cannot figure this out and do not know if it affects issue A. | ||
- | ==== D. Creating SQL database | + | ==== D. Creating SQL database |
- | In order to get the database built, I ran the install.php to generate the SQL and captured it. | + | |
- | Pasted | + | 1. Run the install.php to generate the SQL by checking the box. Copy and paste into a PC file editor. |
- | Changed:\\ | + | 2. Removed formatting spaces to compact, as the SQL parser on the AS/400 has a length limit. |
- | 1. Removed formatting spaces to compact, as the SQL parser on the AS/400 has a length limit. | + | |
- | 2. Split any lines that exceeded 88. There are just a few. | + | 3. Split any lines that exceeded 88. There are just a few. |
- | 3. Fix the error in the SQL generated: | + | 4. Add the required qualifier to tell DB2/400 WHERE to put the tables. |
+ | |||
+ | 5. Fix the error in the SQL generated: | ||
Line 327: | Line 328: | ||
399 ' | 399 ' | ||
- | 4. Save the file as MANTISSQL on the PC | + | 6. Save the file as MANTISSQL on the PC |
- | 5. Create a Source Physical File on the AS/400 | + | 7. Create a Source Physical File on the AS/400 |
Line 342: | Line 343: | ||
CRTSRCPF FILE(MANTIS011/ | CRTSRCPF FILE(MANTIS011/ | ||
- | 6. Add the working LIBRARY to your library list: | + | 8. Add the working LIBRARY to your library list: |
addlible | addlible | ||
- | 7. FTP the mantissql pc file tp MANTIS011/ | + | 9. FTP the mantissql pc file tp MANTIS011/ |
230 ICHANDLER logged on. | 230 ICHANDLER logged on. | ||
Line 364: | Line 365: | ||
ftp: 17753 bytes sent in 0.00Seconds 17753000.00Kbytes/ | ftp: 17753 bytes sent in 0.00Seconds 17753000.00Kbytes/ | ||
- | 8. Once the file is in the source file on the AS/400, execute it by the Run SQL Statement command, shown prompted with F4: | + | 10. Once the file is in the source file on the AS/400, execute it by the Run SQL Statement command, shown prompted with F4: |
Run SQL Statements (RUNSQLSTM) | Run SQL Statements (RUNSQLSTM) | ||
Line 378: | Line 379: | ||
RUNSQLSTM SRCFILE(MANTIS011/ | RUNSQLSTM SRCFILE(MANTIS011/ | ||
- | 9. Congratulations. | + | 11. Congratulations. |
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | http:// |
mantisbt/systemi.txt · Last modified: 2011/12/14 14:54 by atrol