wontonst / teststudy-code

0 stars 0 forks source link

mySQLi files #62

Open lhsairplanes opened 11 years ago

lhsairplanes commented 11 years ago

Hey, where are the files to create the new database, and its respective tables for the davis circles website itself. I can technically create the tables to store our user's data, and wall posts via phpmyadmin, but in that case, I still need to know what tables I need to create and the structure of the tables.

And which files for Davis Circles do we have sql code, and code for accessing and making sql tables?

wontonst commented 11 years ago

i dont' remember exactly where but ihave PHP scripts that generate the course list, the wall tables, etc; they're probably in the library/resources or something like that; i remeber the dirctory being called makedavis or something like that

On Wed, Aug 28, 2013 at 10:36 AM, Jetchan notifications@github.com wrote:

Hey, where are the files to create the new database, and its respective tables for the davis circles website itself. I can technically create the tables to store our user's data, and wall posts via phpmyadmin, but in that case, I still need to know what tables I need to create and the structure of the tables.

And which files for Davis Circles do we have sql code, and code for accessing and making sql tables?

— Reply to this email directly or view it on GitHubhttps://github.com/wontonst/teststudy-code/issues/62 .

lhsairplanes commented 11 years ago

Cool, I spotted the files.

However, I ran "http://daviscircles.com/public_html/application/libraries/DavisWall.php" and it gave me a 404

same 404 when I did "http://daviscircles.com/public_html/resources/walltables/makedavis.php"

What would be the url I should put in to my browser to run the pages to create the sql tables. Since we are using laravel, does our url to access those php pages change? If so to what?

Due to Laravel, everything is after the public folder in the url. In other words, how do I have access to things into the resources folder if I want to run stuff in the resources folder in chrome?

If there is another way of running the php pages to create the sql tables, is it directly through the server via terminal window?

wontonst commented 11 years ago

you run the script directly with php

php myphpfile.php

On Wed, Aug 28, 2013 at 3:18 PM, Jetchan notifications@github.com wrote:

Cool, I spotted the files.

However, I ran " http://daviscircles.com/public_html/application/libraries/DavisWall.php" and it gave me a 404

same 404 when I did " http://daviscircles.com/public_html/resources/walltables/makedavis.php"

What would be the url I should put in to my browser to run the pages to create the sql tables. Since we are using laravel, does our url to access those php pages change? If so to what?

If there is another way of running the php pages to create the sql tables, is it directly through the server via terminal window?

— Reply to this email directly or view it on GitHubhttps://github.com/wontonst/teststudy-code/issues/62#issuecomment-23452956 .

lhsairplanes commented 11 years ago

Wall posting and replies tables have been made, so has the UCD database.

Do you recall where the code for creating the user's information/password SQL table is stored?

Also a small module issue on our homepage www.daviscircles.com that perhaps you know more about than me

wontonst commented 11 years ago

Should all be there, I don't remember where I put it.

On Wednesday, August 28, 2013, Jetchan wrote:

Wall posting and replies tables have been made, so has the UCD database.

Do you recall where the code for creating the user's information/password SQL table is stored?

— Reply to this email directly or view it on GitHubhttps://github.com/wontonst/teststudy-code/issues/62#issuecomment-23457090 .

lhsairplanes commented 11 years ago

Hey, today is my last free day until mid-next week. I have to move apartments and take a midterm. I'll finish up as much as possible today, and can you take over for the next week?

And I don't know what is causing the homepg issue, can you fix that so I can test the login/registration?

wontonst commented 11 years ago

Schools already started for me, lots of work starting to pile up, we'll see

On Wednesday, August 28, 2013, Jetchan wrote:

Hey, today is my last free day until mid-next week. I have to move apartments and take a midterm. I'll finish up as much as possible today, and can you take over for the next week?

— Reply to this email directly or view it on GitHubhttps://github.com/wontonst/teststudy-code/issues/62#issuecomment-23457591 .

lhsairplanes commented 11 years ago

Cools, if that's the case, just look at this issue on the homepg for now.

Error message "include(/var/www/teststudy-code/resources/modules.php): failed to open stream: No such file or directory"

I tried moving a copy of modules.php from trunk/resources/modules.php to truck/public_html/resources/modules.php, as error message indicates to do.

Its something small, but I can't locate it, but my guess is you are more familiar with this specific problem. If you can just get this done so I can go on with more progress, that'd be perfect.

Causing homepg not to show up.

Thanks

lhsairplanes commented 11 years ago

Issue update: Problem located (well almost!)

The home page works now (only with the lines of code referring to the modules commented out).

Problem with the home page and all the Davis Circles pages is that the modules (recall we used modules files for the header and footer) can't be located. This problem started occurring today, and I suspect it is a Laravel thing, since if I recalled correctly, Laravel's routing connects the modules to the web pages.

In other words, I narrowed down the issue to the modules themselves or the Laravel routing. Lemme know if you can take a look at this, but I understand that school is busy for you, so just take a look when you are free.

wontonst commented 11 years ago

remember waht i said about migrating those module files to library? module has nothign to do with laravel, reread my previous post on this

On Wed, Aug 28, 2013 at 10:11 PM, Jetchan notifications@github.com wrote:

Issue update: Problem located (well almost!)

The home page works now (only with the lines of code referring to the modules commented out).

Problem with the home page and all the Davis Circles pages is that the modules (recall we used modules files for the header and footer) can't be located. This problem started occurring today, and I suspect it is a Laravel thing, since if I recalled correctly, Laravel's routing connects the modules to the web pages.

In other words, I narrowed down the issue to the modules themselves or the Laravel routing. Lemme know if you can take a look at this, but I understand that school is busy for you, so just take a look when you are free.

— Reply to this email directly or view it on GitHubhttps://github.com/wontonst/teststudy-code/issues/62#issuecomment-23467392 .

lhsairplanes commented 11 years ago

Its been a while since we work on this and I did a search on the github issues list for the words "migrating", "library", and "modules" and nothing about moving the modules to the library folder surfaced. More info about this would be appreciated.

moreover is it library as in truck/resources/library? (verifiying because there are multiple library directories on the website)

Similarly, on other pages: does sentry need moving too?, but that I don't recall discussing about.

Error Message: (on http://www.daviscircles.com/login) Class 'Sentry' not found

Sorry to be bombarding you with all these messages, but I am trying to get this project back up to speed and am not as familiar with the backend.

wontonst commented 11 years ago

resources/library is our own thing that has nothing to do with laravel, which we want to move to laravel

On Wed, Aug 28, 2013 at 10:52 PM, Jetchan notifications@github.com wrote:

library as in truck/resources/library? (verifiying because there are multiple library directories on the website)

— Reply to this email directly or view it on GitHubhttps://github.com/wontonst/teststudy-code/issues/62#issuecomment-23468603 .