Warning: Table './lavenderweb/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:374:\"Table './lavenderweb/captcha_sessions' is marked as crashed and should be repaired\nquery: INSERT into captcha_sessions (uid, sid, ip_address, timestamp, form_id, solution, status, attempts) VALUES (0, 'd8b3d4f6e2ab8455b7966b3d9484f077', '38.107.179.207', 1337366778, 'comment_form', '412068b202b6cff5e82c9380c9efdf9d', 0, 0)\";s:5:\"%file\";s:80:\"/srv/lavenderwebdesign.co.uk/public/htdocs/sites/all/modules/captcha/captcha.inc\";s:5:\"%line\";i:99;}', 3, '', 'http://www.lavenderwe in /srv/lavenderwebdesign.co.uk/public/htdocs/includes/database.mysql.inc on line 135

Warning: Table './lavenderweb/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:191:\"Table './lavenderweb/captcha_sessions' is marked as crashed and should be repaired\nquery: UPDATE captcha_sessions SET token='fd5b9cdd594073d2fbb2a8def6800945' WHERE csid=0\";s:5:\"%file\";s:83:\"/srv/lavenderwebdesign.co.uk/public/htdocs/sites/all/modules/captcha/captcha.module\";s:5:\"%line\";i:216;}', 3, '', 'http://www.lavenderwebdesign.co.uk/blog/using-git-and-ftp', '', '38.107.179.207', 1337366778) in /srv/lavenderwebdesign.co.uk/public/htdocs/includes/database.mysql.inc on line 135

Warning: Table './lavenderweb/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:150:\"Table './lavenderweb/captcha_sessions' is marked as crashed and should be repaired\nquery: SELECT status FROM captcha_sessions WHERE csid = 0\";s:5:\"%file\";s:80:\"/srv/lavenderwebdesign.co.uk/public/htdocs/sites/all/modules/captcha/captcha.inc\";s:5:\"%line\";i:129;}', 3, '', 'http://www.lavenderwebdesign.co.uk/blog/using-git-and-ftp', '', '38.107.179.207', 1337366778) in /srv/lavenderwebdesign.co.uk/public/htdocs/includes/database.mysql.inc on line 135

Warning: Table './lavenderweb/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:150:\"Table './lavenderweb/captcha_sessions' is marked as crashed and should be repaired\nquery: SELECT status FROM captcha_sessions WHERE csid = 0\";s:5:\"%file\";s:80:\"/srv/lavenderwebdesign.co.uk/public/htdocs/sites/all/modules/captcha/captcha.inc\";s:5:\"%line\";i:129;}', 3, '', 'http://www.lavenderwebdesign.co.uk/blog/using-git-and-ftp', '', '38.107.179.207', 1337366778) in /srv/lavenderwebdesign.co.uk/public/htdocs/includes/database.mysql.inc on line 135

Warning: Table './lavenderweb/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:189:\"Table './lavenderweb/captcha_sessions' is marked as crashed and should be repaired\nquery: UPDATE captcha_sessions SET timestamp=1337366778, solution='Q6ShN' WHERE csid=0\";s:5:\"%file\";s:80:\"/srv/lavenderwebdesign.co.uk/public/htdocs/sites/all/modules/captcha/captcha.inc\";s:5:\"%line\";i:111;}', 3, '', 'http://www.lavenderwebdesign.co.uk/blog/using-git-and-ftp', '', '38.107.179.207', 1337366778) in /srv/lavenderwebdesign.co.uk/public/htdocs/includes/database.mysql.inc on line 135
Using GIT and FTP | Lavender Web Design

Using GIT and FTP

Posted by: Robert Lavender on Tuesday, August 23rd, 2011

As promised here's the second part on GIT, to complete your process of deploying your website to the server.

Now I’ve got GIT installed and I can track my projects using GIT. I’ve setup a GIT repository on GITHUB and can connect to it.

Something that has always bugged me about any version control is how do you connect your updates with your web server that you want to push everything to?

There’s a couple of options:

Set up a GIT repository on your server and update that. This always seems a little clunky as you’d end up having all the GIT files on the server, so that doesn’t work for me.

Pushing out any updates to the server seems the best option, and there seems to be a couple of solutions. GIT hooks or GIT-FTP.

GIT Hooks - gave this a try but was unable to figure it out.

So GIT-FTP is the winner, lets get it started.

https://github.com/resmo/git-ftp

http://superuser.com/questions/155188/snow-leopard-make-command-not-foun...

Help? The make command on terminal isn’t working. Now it looks like I need Apple x-Code developer kit which I can download or install from the original installation disks that came with the computer.

http://stackoverflow.com/questions/2556444/install-make-command-without-...

The Developer Tools are included on the OS X install disk under “Optional Installs”.

Update: Installing git-ftp

I had a little trouble, after I installed x-code on the mac, installing git-ftp as per the install instructions was fine, but it still wouldn’t run. Then I remembered something about adding the path to .profile. Following the instructions in Getting Good with GIT it looks like it’s working.

Getting Good with GIT: Chapter 3

We’re going to be installing Git to the /usr/local directory, so you want to make sure that Terminal will be able to find it in the $PATH. Using the command we talked about above, check for the /usr/ local/bin path ( bin stands for binary, and is the sub-directory that your compiled Git programs will be stored in). If it’s not there, open .profile and add this line to the end
$ sudo brew install git
$ sudo port selfupdate
$ sudo port install git-core
export PATH=”/usr/local/bin:$PATH”

TIP
What’s .profile? The Mac Terminal uses a file called .profile to keep track of command line customizations; as you get more accustomed to the command line, you’ll find yourself going to it and other files to make edits. the .profile file is in your home directory, but you won’t be able to see it by default. The easiest way to get to it is via the Terminal command mate ~/.profile; replace “mate” with your editor of choice!
After you save and close .profile, restart Terminal. Running echo $PATH should now show you that /usr/local/bin is in your $PATH.

Ok, so now I’ve installed X-Code and I’ve add the location to the path I can now install GIT-FTP.

Setting up config

Although GIT-FTP is a little slow at FTPing files to the server, so the initial upload takes a long time, this looks like a good solution.
to speed thing up a little you can also add your FTP details to the GIT config file:

Setting defaults for a git project in .git/config

$ git config git-ftp.user john
$ git config git-ftp.url ftp.example.com
$ git config git-ftp.password secr3t

Pushing for the first time:

$ git ftp init

Then after that all you need to do is use following command to keep your website up to date.

$ git ftp push

Great now we have a complete system.
 

Leave a comment...

The content of this field is kept private and will not be shown publicly.
If you have your own website, enter its address here. (please include http://).
eg. http://www.yourdomainname.co.uk
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.