Error Apache 2 Invalid command '\xef\xbb\xbf

Starting Apache Web Server...
Exit code: 8
Stdout:
apache config test fails, aborting
Stderr:
AH00526: Syntax error on line 1 of /opt/lampp/apache2/conf/httpd.conf:
Invalid command '\xef\xbb\xbfAlias', perhaps misspelled or defined by a module not included in the server configuration

Este error surge porque la codificación utf8 agregar caracteres adicionales que el apache interpreta como parte del comando.

Solución:

Gardar el archivo de texto como: En el menú Herramientas elegimos Codificación y luego ISO 8859-1

[YII] Netbeans 7.4 integracion Yii Framework

Yii plugin adds useful enhancements to NetBeans IDE including the following:

• Code completion in views (including variables passed to view and $this).
• Go To Action, Go To View.
• Go to view via clicking on render or renderPartial argument.
• Go to file via clicking on path alias (Yii::import, widget, beginWidget,createWidget, beginCache).
• New project wizard.

BAJAR PLUGIN

AGREGAR EL TEMPLATE AL EDITOR DEL NETBEANS O AGREGARLOS MANUALMENTE AL EDITOR:

http://www.cheatography.com/hoplayann/cheat-sheets/yii-code-templates-for-netbeans/

You can create code templates for commonly used/overridden function in Yii. For example, if you want to add an beforeSave() function in your model, by typing a shortcut you can automatically have the function template in place. There are additional shortcuts for common stuff like Yii::app(), Yii::t(), Yii::app()->user->checkAccess(), and more!

• Download this template set to get started: http://fbe.am/hly (version 2). View all available commands in this printable cheat sheet.
• Go to "Tools > Options > Editor > Code Templates"
• Hit "Import", select the file, and choose "Code Templates"
  • You might get an error message "invalid zip file" if you are importing to a older/newer version of NetBeans. Open up the zip file, edit build.info, and set the correct path to Userdir.

Usage:

• Type the shortcut and hit TAB
• More info: NetBeans Doc

o BAJAR Y INSTALAR EN EL DIRECTORIO DEL NETBEANS:

TEMPLATE

Navigation

Run Command

Code Completion

Usage

Install Plugin

Download a nbm file or create it by yourself. And please, install it.

How to enable

• Use default directory structure (don't delete yiic* files)
• project properties > Framework > Yii, check enabled (You don't have to check this if you use plugin with default app)

Existing Source

Source directory : Please, specify the webroot directory
Webroot directory : Please, keep default (Source directory)

e.g.

testdrive (webroot directory)
├── assets
├── css
├── images
├── index-test.php
├── index.php
├── nbproject
├── protected
└── themes

Existing Source (Source Directory has other directories)

Please set webroot directory(yii path alias named "webroot" i.e. webroot is testdrive on the below tree) to webroot of project properties.

Right-click project > properties > Source > Webroot

e.g.

my_source (source directory)
├── testdrive (webroot directory)
│   ├── assets
│   ├── css
│   ├── images
│   ├── index-test.php
│   ├── index.php
│   ├── protected
│   └── themes
│ 
├── ...
├── foo
└── bar

Path settings

You can set the some paths(e.g. path alias) to project properties. If you use defferent path from default, please set relative path there from source directory.

I have added path settings to project properties.

Usage

Please set relative path from source directory.
e.g.
Please set protected/myext to ext: if extensions directory is the following:

myproject
├─protected
│  └─myext (extensions directory)
├─...

If you want to use default directory, please set empty.
e.g.
application: myprotected
controllers: (empty)
views: (empty)

controllers directory means myprotected/controllers. views directory means myprotected/views.

Features

• Badge icon
• Go To Action
• Go To View
• Code Completion on the view file
• Code Completion for the path
• Init Action
• PHPUnit Test Init Action
• New Yii Project Wizard
• Run Action Action
• Navigation for path alias (Hyperlink to file)
• Run Command Action

Go To Action

You can open the controller file and move action method.

e.g. WebRoot/protected/views/site/index.php -> WebRoot/protected/controllers/SiteController.php::actionIndex()

1. open a view file
2. Right-click on Editor
3. Navigate > Go To Action

Go to View

You can open the view file for action method of the controller.(similar to Go To Action)

1. open a controller file
2. move the caret to action method
3. Right-click on Editor
4. Navigate > Go To View

If you set the keymap for this action, it's more useful.(Please, search with "php")
If you set the theme on main.php, you will go to there.

// protected/main.php
// e.g. set themes/basic
array(
    // something...
    'theme' => 'basic',
);

Hyper link to view file

You can open the view file from parameter of render and renderPartial methods. This is available on the Controller or View files.

e.g.

public actionIndex() {
    // something ...

    $this->render('foo', array('bar' => $bar));
    $this->renderPartial('bar');
}

When you use the render method like above, if foo.php exists, you do the following.

fallback to default views

You can fallback to default views if view file for your theme doesn't exist when you use the theme. If you would like to this feature, please, check "Fallback to ..." on project properties for Yii.

1. Hold down Ctrl key on the first parameter (foo)
2. Wait to be changed string color to blue
3. Click (foo)

It will go to theme file if you use theme.

Navigation for path alias (Hyperlink to file)

Usage is the same as hyperlink to view file.

This feature is available for the followings:

• Yii::import()
• Yii::t()
• CBaseController::widget()
• CBaseController::beginWidget()
• CBaseController::endWidget()
• CBaseController::createWidget()
• CBaseController::beginCache()
• CBaseController::beginContent()

1. Hold down Ctrl on target path
2. string color is changed to blue if file exists(file path is displeyed as tooltip)
3. Click > open file

e.g.

$this->widget('application.components.MyComponent', array());
// Hold down Ctrl on application.components.MyComponent

// support for the path that starts with '/' and '//'
$this->beginContent('//layouts/main');
$this->renderPartial('/users/foo');

// support for the class name
$this->widget('MyWidget');

Furthermore... Class name is also valid at the other places.
e.g.

return array(
    'some'=>array(
        // Hold-down Ctrl key on 'ClassName'
        'class'=>'SomeAction',
    ),
);

i18n

Yii::t('Xyz.categoryName', 'message to be translated');
// on the first parameter : open the message file for LanguageID
// on the second parameter :  open the message file for LanguageID, and caret position is moved to specified message

Notice

• This feature works with default path alias name.
• Automatically file creation is valid with only render and renderPartial methods.

Code Completion on the view file

Provide support for code completion on the View file.

e.g. webapp/protected/controllers/SiteController.php

class SiteController extends Controller {
    // something...

    public function actionIndex(){
        // ...
        $this->render('foo', array(
            'var1' => $var,
            'var2' => 'bar',
        ));
    }
}

e.g. webapp/protected/views/site/index.php

$ // [Ctrl + Space] popup $var1, $var2, $this, ...
$this-> // [Ctrl + Space] popup SiteController methods and fields

Code Completion for the path

This is available the following methods:

• render
• renderPartial
• beginContent
• beginCache
• import
• *widget

e.g.

// type character or [Ctrl + Space]
$this->render('i');

// class or path alias
$this->widget('application.[Ctrl + Space]');

Init Action

Run the followings:

• Set framework directory path to Project Properties.
• Create a file for code completion.

Project right-click > Yii > Init

 Testing 

To run functional tests and unit tests in Yii, recommended is installing PHPUnit and SeleniumRC.

• Install PHPUnit
  • Follow the official version 3.6 installation instructions.
  • Open "Tools > Options > PHP > Unit Testing" and set the correct path to the launch script. This is phpunit.bat in Windows and usually /usr/bin/phpunit in Linux.
• Install SeleniumRC by getting the NetBeans plugin
  • Open "Tools > Plugins > Available Plugins"
  • Install "Selenium Module for PHP"
• Configure project options
  • Open "File > Project properties > Sources" and set "Test Folder" to [PROJECT ROOT]/protected/tests (If the whole project testing doesn't work, try [PROJECT ROOT]/protected/tests/unit)
  • Open "File > Project properties > PHPUnit" and set "Use Bootstrap" to [PROJECT ROOT]/protected/tests/bootstrap.php, and "Use XML Configuration" to [PROJECT ROOT]/protected/tests/phpunit.xml

Usage:

• Test whole project: Alt+F6
• Test single file: Shift-F6
• Check code coverage (right click project > Code Coverage)

4. Debugging 

• Install Xdebug (usually already available in your installation):
  • Follow the official installation instructions.
• Include the Xdebug extension for PHP:
  • In php.ini enable (by removing ; prefix) these settings:

    zend_extension = "C:\xampp\php\ext\php_xdebug.dll"
    xdebug.remote_enable = 1
    xdebug.remote_handler = "dbgp"
    xdebug.remote_host = "localhost"
    xdebug.remote_port = 9000

Usage:

• Debug project: Ctrl-F5
• Use breakpoints, walk through running code, and watch variables and objects in real-time. :)
• If you want to stop the debugger from pausing on the first line for every request, simply turn that "feature" off by clicking: Tools > Options > PHP > Debugging > Stop at First Line (uncheck)

[SHELL]Ver las variables de entorno de Linux/Unix

El compando export, sirve para agregar variables de sistema para distintas aplicaciones por ej: para el caso de java JAVA_HOME, si tenemos shell corriendo etc.
Por ejemplo:

usuario@acura:~$ export
declare -x HOME="/home/usuario"
declare -x LANG="en_GB.UTF-8"
declare -x LANGUAGE="en_GB:en"
declare -x LC_ADDRESS="en_US.UTF-8"
declare -x LC_IDENTIFICATION="en_US.UTF-8"
declare -x LC_MEASUREMENT="en_US.UTF-8"
declare -x LC_MONETARY="en_US.UTF-8"
declare -x LC_NAME="en_US.UTF-8"
declare -x LC_NUMERIC="en_US.UTF-8"
declare -x LC_PAPER="en_US.UTF-8"
declare -x LC_TELEPHONE="en_US.UTF-8"
declare -x LC_TIME="en_US.UTF-8"
declare -x LESSCLOSE="/usr/bin/lesspipe %s %s"
declare -x LESSOPEN="| /usr/bin/lesspipe %s"
declare -x LOGNAME="usuario"
declare -x LS_COLORS="rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.war=01;31:*.ear=01;31:*.sar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.webm=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=00;36:*.au=00;36:*.flac=00;36:*.mid=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mpc=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:*.axa=00;36:*.oga=00;36:*.spx=00;36:*.xspf=00;36:"
declare -x MAIL="/var/mail/usuario"
declare -x OLDPWD
declare -x ORACLE_HOME="/Oracle/app/product/11.2.0/dbhome_1"
declare -x ORACLE_SID="BERR"
declare -x PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/Oracle/app/product/11.2.0/dbhome_1/bin"
declare -x PWD="/home/usuario"
declare -x SHELL="/bin/bash"
declare -x SHLVL="1"
declare -x SSH_CLIENT="10.10.30.9 50309 22"
declare -x SSH_CONNECTION="10.10.30.9 50309 192.168.40.21 22"
declare -x SSH_TTY="/dev/pts/6"
declare -x TERM="xterm"
declare -x USER="usuario"
declare -x XDG_SESSION_COOKIE="8c19c58df429568648ecf60c00000638-1394136889.281238-1263694637"

[UML] Dicccionario de datos con MYSQL workbench 5.2.33 CE o superior

 Primero tener instalado MYSQL workbench 5.2.33 o superior, no importa el sistema operativo.
Bajar plugin para el WB desde:

wb-datadict/downloads

Seguir los pasos a continuacion:

Debaria aparecer al final de instalar:

Una vez reiniciado el WB ir a un modelo ER y:

Guardar como HTML y el modelo saldra algo como:

sakila
Data Dictionay

2014-03-05

Alphabetic Index

• actor
• address
• category
• city
• country
• customer
• film
• film_actor
• film_category
• film_text
• inventory
• language
• payment
• rental
• staff
• store

actor

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
actor_id	SMALLINT	✔	✔			✔		✔
first_name	VARCHAR(45)		✔
last_name	VARCHAR(45)		✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

address

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
address_id	SMALLINT	✔	✔			✔		✔
address	VARCHAR(50)		✔
address2	VARCHAR(50)								NULL
district	VARCHAR(20)		✔
city_id	SMALLINT		✔			✔
postal_code	VARCHAR(10)								NULL
phone	VARCHAR(20)		✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

category

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
category_id	TINYINT	✔	✔			✔		✔
name	VARCHAR(25)		✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

city

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
city_id	SMALLINT	✔	✔			✔		✔
city	VARCHAR(50)		✔
country_id	SMALLINT		✔			✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

country

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
country_id	SMALLINT	✔	✔			✔		✔
country	VARCHAR(50)		✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

customer

Table storing all customers. Holds foreign keys to the address table and the store table where this customer is registered. Basic information about the customer like first and last name are stored in the table itself. Same for the date the record was created and when the information was last updated.
Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
customer_id	SMALLINT	✔	✔			✔		✔
store_id	TINYINT		✔			✔
first_name	VARCHAR(45)		✔
last_name	VARCHAR(45)		✔
email	VARCHAR(50)								NULL
address_id	SMALLINT		✔			✔
active	TINYINT(1)		✔						TRUE
create_date	DATETIME		✔
last_update	TIMESTAMP								CURRENT_TIMESTAMP

film

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
film_id	SMALLINT	✔	✔			✔		✔
title	VARCHAR(255)		✔
description	TEXT								NULL
release_year	YEAR								NULL
language_id	TINYINT		✔			✔
original_language_id	TINYINT					✔			NULL
rental_duration	TINYINT		✔			✔			3
rental_rate	DECIMAL(4,2)		✔						4.99
length	SMALLINT					✔			NULL
replacement_cost	DECIMAL(5,2)		✔						19.99
rating	ENUM('G','PG','PG-13','R','NC-17')								'G'
special_features	SET('Trailers','Commentaries','Deleted Scenes','Behind the Scenes')								NULL
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

film_actor

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
actor_id	SMALLINT	✔	✔			✔
film_id	SMALLINT	✔	✔			✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

film_category

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
film_id	SMALLINT	✔	✔			✔
category_id	TINYINT	✔	✔			✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

film_text

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
film_id	SMALLINT	✔	✔			✔
title	VARCHAR(255)		✔
description	TEXT								NULL

inventory

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
inventory_id	MEDIUMINT	✔	✔			✔		✔
film_id	SMALLINT		✔			✔
store_id	TINYINT		✔			✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

language

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
language_id	TINYINT	✔	✔			✔		✔
name	CHAR(20)		✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

payment

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
payment_id	SMALLINT	✔	✔			✔		✔
customer_id	SMALLINT		✔			✔
staff_id	TINYINT		✔			✔
rental_id	INT								NULL
amount	DECIMAL(5,2)		✔
payment_date	DATETIME		✔
last_update	TIMESTAMP								CURRENT_TIMESTAMP

rental

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
rental_id	INT	✔	✔					✔
rental_date	DATETIME		✔
inventory_id	MEDIUMINT		✔			✔
customer_id	SMALLINT		✔			✔
return_date	DATETIME								NULL
staff_id	TINYINT		✔			✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

staff

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
staff_id	TINYINT	✔	✔			✔		✔
first_name	VARCHAR(45)		✔
last_name	VARCHAR(45)		✔
address_id	SMALLINT		✔			✔
picture	BLOB								NULL
email	VARCHAR(50)								NULL
store_id	TINYINT		✔			✔
active	TINYINT(1)		✔						TRUE
username	VARCHAR(16)		✔
password	VARCHAR(40)				✔				NULL
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP

store

Column name	DataType	PK	NN	UQ	BIN	UN	ZF	AI	Default	Comment
store_id	TINYINT	✔	✔			✔		✔
manager_staff_id	TINYINT		✔			✔
address_id	SMALLINT		✔			✔
last_update	TIMESTAMP		✔						CURRENT_TIMESTAMP