Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000445sigmah website[All Projects] Generalpublic2012-03-24 15:502012-06-25 15:32
ReporterspM 
Assigned Toosarrat 
PriorityhighSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOSUbuntuOS Version10.10
Product Version 
Target VersionFixed in Version2012w25 
Summary0000445: Getting the sigmah-website code up and working on your machine
DescriptionFrom 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 ReproduceSet 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 InformationI 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 :)
TagsNo tags attached.
Attached Filespng file icon Screenshot.png [^] (81,044 bytes) 2012-03-24 15:50

- Relationships

-  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
Powered by Mantis Bugtracker