Create article from PHP - Joomla! Forum - community, help and support

hi! i'm new user forum, don't know if i'm using correct topic.
recently developped php code delete article. here post code:

code: select all

$p = dirname(dirname(__file__));
define('joomla_minimum_php', '5.3.10');

if (version_compare(php_version, joomla_minimum_php, '<'))
{
    die('your host needs use php ' . joomla_minimum_php . ' or higher run version of joomla!');
}

$starttime = microtime(1);
$startmem  = memory_get_usage();

define('_jexec', 1);

if (file_exists($p . '/defines.php'))
{
    include_once $p . '/defines.php';
}

if (!defined('_jdefines'))
{
    define('jpath_base', $p);
    require_once jpath_base . '/includes/defines.php';
}

require_once jpath_base . '/includes/framework.php';

$idarticle=23;

$db = jfactory::getdbo();

$query = $db->getquery(true);

$conditions = array(
     $db->quotename('id') . " = $idarticle",
);

$query->delete($db->quotename('#__content'));
$query->where($conditions);

$db->setquery($query);

$result = $db->execute();


after execute code, i've got error while create article (with joomla's administration procdure):

error displaying error page: table 's' not locked lock tables sql=select template, s.params #__template_styles s left join #__extensions e on e.type='template' , e.element=s.template , e.client_id=s.client_id s.client_id = 1 , home = '1' order home: unknown column 'alias' in 'field list' sql=update `#__assets` set `name`='com_content.article.6',`title`='test article',`rules`='{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1},\"core.create\":{\"3\":1},\"core.delete\":[],\"core.edit\":{\"4\":1},\"core.edit.state\":{\"5\":1},\"core.edit.own\":[]}',`parent_id`='27',`level`='3',`lft`='23',`rgt`='24',`alias`=null `id`='68'

on own, code goes , above all, can change resolve error?

in opinion, since db nested, when remove article "content" table, forget delete/update other tables...but don't know which!

thanks