| Anonymous | Login | Signup for a new account | 2013-05-21 21:34 CEST | ![]() |
| Main | My View | View Issues | Change Log | Roadmap | My Account |
| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |
| 0000445 | sigmah website | [All Projects] General | public | 2012-03-24 15:50 | 2012-06-25 15:32 | |
| Reporter | spM | |||||
| Assigned To | osarrat | |||||
| Priority | high | Severity | major | Reproducibility | sometimes | |
| Status | closed | Resolution | fixed | |||
| Platform | OS | Ubuntu | OS Version | 10.10 | ||
| Product Version | ||||||
| Target Version | Fixed in Version | 2012w25 | ||||
| Summary | 0000445: Getting the sigmah-website code up and working on your machine | |||||
| Description | From what I see in the code, the sigmah website has probably been built on a windows based platform. *When I downloaded the sigmah-website code from the github page, all the folders had a 700 permission, and many files(viz images, css and js) also had wrong permissions, hence many errors were being being thrown up, and many images broken on the page in the first place. *CLean URLS are enabled by default, which needs some configuration at times in the local httpd.conf files, that is also not mentioned in the documentation ex. <Directory 'path-to-your-web-folder' > AllowOverride All </Directory> | |||||
| Steps To Reproduce | Set up a LAMP server on your linux Box. Copy the contents of the downloaded zip to your web folder, Check permissions with `ls -l`. Infact to note the permissions of all the directories and subdirectories, do ls -l `find . -type d` | awk '{print $1}' | |||||
| Additional Information | I guess, this should need a careful consideration, on a linux apache server itself. And once the ext permissions are set, the website would work equally both on Linux and Windows and Mac , and hence with easier being the "getting started with the code" part, more would be the developers we have who are intrested to contribute :) | |||||
| Tags | No tags attached. | |||||
| Attached Files | ||||||
Notes |
|
|
(0000877) osarrat (administrator) 2012-03-28 15:23 |
Thanks for reporting this issue! Regarding the developer environment on the sigmah website project, we should also develop a post-commit hook script on GitHub which will link commits on GitHub with our Mantis issue tracker. Would be another issue. |
|
(0000923) spM (developer) 2012-05-11 22:32 |
https://github.com/spMohanty/sigmah-website/commit/2f02ae63b065fd93ce15ad48dfb0a98aae89093f [^] , this commit adds more information to the Readme file, to make it easier to set up the project on your local machine. |
|
(0000935) osarrat (administrator) 2012-05-21 15:01 |
The new sigmah_website.sql file cannot be imported through PhpMyAdmin. Its importation (after having zipping it) returns the following error: ----------------------------------- SQL query: SELECT `comment` FROM `phpmyadmin`.`pma_column_info` WHERE db_name = 'sigmah_website' AND table_name = '' AND column_name = '(db_comment)' MySQL a répondu: Documentation #1100 - Table 'pma_column_info' was not locked with LOCK TABLES ----------------------------------- But the script has passed through MySQL Workbench. |
|
(0000943) spM (developer) 2012-05-21 20:09 |
I tried installing a fresh copy, but I was unable to reproduce the issue. :( But why do you have to zip it before importing ? PhpMyAdmin lets you import raw sql files am sure !! And, the sigmah_website.sql file's main purpose is to "create" an instance of the database. and this query up here, doesnot update any table or add rows to a table, it only asks for information, so I dont think, this query failing will have any effect of the database instance of the site. And i suspect this error is more of a local problem, not because of anything in the sigmah_website.sql file. and that because, the sql file was created using linux mysqldump and theres no way something like "phpmyadmin" would turn up in its output. And also, I tried manually searching for "phpmyadmin" in the sqldump, and it was not there. This must have been an error from your phpmyadmin instance. |
|
(0000972) osarrat (administrator) 2012-06-25 15:31 |
I have to zip the SQL file before importation with PhpMyAdmin because my instance only accepts files smaller than 8MB. So a 60MB file is far too large... I've tried once again to import the file through PhpMyAdmin and it didn't work. As a conclusion, we should agree to use direct command line or MySQL Workbench importation. |
|
(0000973) osarrat (administrator) 2012-06-25 15:32 |
Issue closed because correct behavior checked on version 2012w25. |
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2012-03-24 15:50 | spM | New Issue | |
| 2012-03-24 15:50 | spM | File Added: Screenshot.png | |
| 2012-03-28 15:23 | osarrat | Note Added: 0000877 | |
| 2012-05-11 22:32 | spM | Note Added: 0000923 | |
| 2012-05-21 15:01 | osarrat | Note Added: 0000935 | |
| 2012-05-21 20:09 | spM | Note Added: 0000943 | |
| 2012-06-25 15:31 | osarrat | Note Added: 0000972 | |
| 2012-06-25 15:32 | osarrat | Note Added: 0000973 | |
| 2012-06-25 15:32 | osarrat | Status | new => closed |
| 2012-06-25 15:32 | osarrat | Assigned To | => osarrat |
| 2012-06-25 15:32 | osarrat | Resolution | open => fixed |
| 2012-06-25 15:32 | osarrat | Fixed in Version | => 2012w25 |
| Copyright © 2000 - 2010 MantisBT Group |