March 2011 - support - lists.drupal.org

Views newbie question
by Austin Einter 31 Mar '11

31 Mar '11

Hi All Lets, we have stored the data "Job seekers details" in MySql tables. If an employer wants to see the job seekers details with certain condition - Say 1. job seeker skill == PHP OR 2. job seeker preferred work location == Texas OR 3. job seekers experience == 15 yeras Then, I hope we can use Views module to show the records dynamically to employer. Can somebody give me a high level hint, how it is acheived using Views (a simple example will help me to great extent). My thought is I should provide a "search form", let employeer fill the corresponding data in search form, once click the *search button* then , a new page must show a table, where each row corresponds to an job seeker's profile. Thanks and Regards Austin

2 1

Drupal 7 multilingual sites
by Adam Tong 31 Mar '11

31 Mar '11

Hi, I tried to install the module il8n. Drupal gave me the following message: i18n-6.x-1.9.tar.gz contains versions of modules or themes that are not compatible with Drupal 7.x: Internationalization tests, Taxonomy translation, Synchronize translations, String translation, Profile translation, Poll aggregate, Menu translation, Content type translation, CCK translation, Block translation, Internationalization I don't know what to do. What is the best way to make a multilingual site using drupal 7? Thank you

2 1

Re: [support] Images not showing on nodes (Showing only image name)
by Marty Landman 30 Mar '11

30 Mar '11

I'm looking at the first image on your corporate-cakes link - 1474 - and it's miscoded. Instead of having the url for the image file inside the image tag there's a link, ie. an 'a href=' inside the image tag. Try devel theme developer to trace where that's happening. hth, Marty At 03:51 PM 3/30/2011, Mutuku Ndeti wrote: >I checked permissions. > >@walter, the site is http://www.valentinecakehouse.co.ke . Example of >a node is http://www.valentinecakehouse.co.ke/corporate-cakes > >I have checked "Display fields" and the settings are ok. > > > >On 30/03/2011, Ryan LeTulle <bayousoft(a)gmail.com> wrote: > > I guess. Did you check permissions? > > * > > > > Ryan LeTulle* > > > >> bayousoft <http://twitter.com/bayousoft> -twitter > > > > > > > > > > > > > > > > > > On Wed, Mar 30, 2011 at 1:09 PM, Mutuku Ndeti <jnmutuku(a)gmail.com> wrote: > > > >> could the issue be this error "The selected file * > >> /home/mysitefolder/public_html/tmp/fileqp0K5D* could not be copied." I > >> keep getting many of them > >> > > > > >-- >Tel:254722490994 >www.agile.co.ke | www.zetu.co.ke >-- >[ Drupal support list | http://lists.drupal.org/ ] -- http://www.face2interface.com/ https://addons.mozilla.org/af/firefox/addon/181910/

1 0

FW: messed up variable?
by Mike Pearson 30 Mar '11

30 Mar '11

Have a look at http://drupal.org/project/variablecheck which has a D7 version as well as D6. This solved a problem for me on a D6 site that I couldn't track down any other way. Hope it works for you too. Mike _____ From: Ursula Pieper [mailto:dramamezzo@gmail.com] Sent: 30 March 2011 02:55 To: support(a)drupal.org Subject: [support] messed up variable? I moved my sites to a different host (aside: VPS makes a big difference over shared hosting!), and for one of the sites, I get this error message until the cache is built, and then again after clearing the cache: Notice: unserialize() [function.unserialize]: Error at offset 2 of 21 bytes in variable_initialize() (line 749 of myhomedirectory/www/includes/bootstrap.inc). I searched the web, but didn't find anything that could help me. Any suggestions on how to find the problem? I am running drupal 7, and have listed the installed modules below. Thanks, Ursula Backup and Migrate 7.x-2.1 7.x-2.1 Up to date Drupal core 7.0 7.0 Up to date CAPTCHA 7.x-1.0-alpha2 7.x-1.0-alpha2 Up to date Chaos tool suite 7.x-1.0-alpha4 7.x-1.0-alpha4 Up to date Date 7.x-1.0-alpha2 7.x-1.0-alpha2 Up to date Google Analytics 7.x-1.2 7.x-1.2 Up to date Link 7.x-1.0-alpha3 7.x-1.0-alpha3 Up to date Location Map 7.x-1.0 7.x-1.0 Up to date Meta tags quick 7.x-1.2 7.x-1.2 Up to date Page Title 7.x-2.4-beta1 7.x-2.4-beta1 Up to date Pathauto 7.x-1.0-beta1 7.x-1.0-beta1 Up to date Redirect 7.x-1.0-beta1 7.x-1.0-beta1 Up to date Token 7.x-1.0-beta1 7.x-1.0-beta1 Up to date Views 7.x-3.0-beta3 7.x-3.0-beta3 Up to date Zen 7.x-3.x-dev 7.x-3.x-dev Up to date

2 1

messed up variable?
by Ursula Pieper 30 Mar '11

30 Mar '11

I moved my sites to a different host (aside: VPS makes a big difference over shared hosting!), and for one of the sites, I get this error message until the cache is built, and then again after clearing the cache: Notice: unserialize() [function.unserialize]: Error at offset 2 of 21 bytes in variable_initialize() (line 749 of myhomedirectory/www/includes/bootstrap.inc). I searched the web, but didn't find anything that could help me. Any suggestions on how to find the problem? I am running drupal 7, and have listed the installed modules below. Thanks, Ursula Backup and Migrate 7.x-2.1 7.x-2.1 Up to date Drupal core 7.0 7.0 Up to date CAPTCHA 7.x-1.0-alpha2 7.x-1.0-alpha2 Up to date Chaos tool suite 7.x-1.0-alpha4 7.x-1.0-alpha4 Up to date Date 7.x-1.0-alpha2 7.x-1.0-alpha2 Up to date Google Analytics 7.x-1.2 7.x-1.2 Up to date Link 7.x-1.0-alpha3 7.x-1.0-alpha3 Up to date Location Map 7.x-1.0 7.x-1.0 Up to date Meta tags quick 7.x-1.2 7.x-1.2 Up to date Page Title 7.x-2.4-beta1 7.x-2.4-beta1 Up to date Pathauto 7.x-1.0-beta1 7.x-1.0-beta1 Up to date Redirect 7.x-1.0-beta1 7.x-1.0-beta1 Up to date Token 7.x-1.0-beta1 7.x-1.0-beta1 Up to date Views 7.x-3.0-beta3 7.x-3.0-beta3 Up to date Zen 7.x-3.x-dev 7.x-3.x-dev Up to date

2 1

FCKeditor
by Sivahari Nandakumar 30 Mar '11

30 Mar '11

In FCKeditor's image insert option the browse server option is not there how to enable it. In fckconfig.js all options are true. -- with warm regards Sivahari Nandakumar Appropriate Technology Promotion Society Eroor, Vyttila 09446582917 http://sivaharicec.blogspot.com -------------------------------------------------------- fighting for knowledge freedom

2 3

How to get the auto-increment value
by Austin Einter 29 Mar '11

29 Mar '11

Hi All I have a table, where 'cid' field is of type "serial". Schema declaration is -> *"'cid' => array('type' => 'serial', 'unsigned' => TRUE, 'not null' => TRUE, ),"* Aim is to have an incremented value for it. The code is as below *$lastid = 0; for($delta = 0; $delta < $all_companies; $delta++) { $lastid = db_last_insert_id(rs_companies, cid) + 1; db_query( 'INSERT INTO {rs_companies} ( cid, uid, prevcompany, joindate, releasedate) ' ."VALUES (%d, '%d', '%s', '%d', '%d')", $lastid, * With this, I find this 'cid' field is not auto incrementing. Any idea, whats the wrong here. Best Regards Austin.

3 3

Doubt on Index and Primary key
by Austin Einter 29 Mar '11

29 Mar '11

HI All In .install file, in hook_schema unction, we are mentioning index field and primary key field. I am wondering, how to choose which one should be index and which one should be primary key. Does that affect the performance (in search, add, delete of records). What I am thinking at this point of time, my database will contain job seekers name, mail-id, contact number, skill set (as comma separated values) and resume. For index purpose, I am thinking I will use '$user->uid' as Index and and 'name' as primary key. I am bit confused how it it is going to affect search/add/delete time (assuming huge number of records in database) and also database management. Please guide me. Regards Austin

5 15

Custom user experience
by Joel Willers 28 Mar '11

28 Mar '11

I’ve got a project where the client wants users to be able to move around their landing page to organize it the way they want. I was thinking about tying a content type to their account that just had weights for each section and then building the landing page based on those weights. This is a really simple solution, though, and I was wondering if perhaps there was something more elegant with the ability to drag and drop the sections into their new spaces and then save the layout. If a module already exists, that would be nice. Thoughts? Joel

4 6

Re: [support] [development] How to get the auto-increment value
by Austin Einter 28 Mar '11

28 Mar '11

Hi All As you suggested, I changed the code where I do not put auto-increment field in db_query. The code looks as below (Please note that $cid is not used in db_query). * for($delta = 0; $delta < $all_companies; $delta++) { drupal_set_message(t('delta = ').$delta.t('last id = ').db_last_insert_id(rs_companies, cid)); db_query( 'INSERT INTO {rs_companies} (uid, prevcompany, joindate, releasedate) ' ."VALUES ('%d', '%s', '%d', '%d')", $user->uid, $form_state['values']['allcompanies'][$delta]['companies'], $form_state['values']['allcompanies'][$delta]['startdate'], $form_state['values']['allcompanies'][$delta]['enddate'] );* So I have not put $cid, when I checked the table, I see $cid values are inserted properly. $cid in row 1 value is 155694 $cid in row 2 value is 155695 $cid in row 3 value is 155696 etc... My question is , why the value is starting from 155694, why not from 0 or 1. Is there anyway I force it to start from 0 or 1. Regards Austin. On Mon, Mar 28, 2011 at 7:50 PM, Larry Garfield <larry(a)garfieldtech.com>wrote: > Yep, you're doing it backwards, actually. :-) > > In D6: > > db_query("INSERT INTO {foo} (a, b) VALUES (%d, '%s')", 1, 'hi'); > $cid = db_last_insert_id(); // The DB auto-generated this value. > > In D7: > > $cid = db_insert() > ->fields(array( > 'a' => 1, > 'b' => 'hi' > )) > ->execute(); > // db_insert()->execute() returns the new auto-inc value automatically. > > Note: In D7, you can do a multi-insert statement where several inserts run > as > a set. That is faster than issuing separate queries, but the return value > is > then undefined and you do not have access to the last-insert-id. Decide if > you *actually* need to auto-generated ID right then and then pick > multi-insert > or not as appropriate. > > As to your other question, the max number of rows, bear in mind that the > number of rows may not correspond go the largest auto-inc value. If you > ever > delete a row then the two will no longer match up. Depending on which you > care about, either of the following are valid (this is D7 syntax): > > $num_records = db_query("SELECT COUNT(*) FROM {foo}")->fetchField(); > > $max_cid = db_query("SELECT MAX(cid) FROM {foo}")->fetchField(); > > Cheers. > > --Larry Garfield > > On Monday, March 28, 2011 5:59:14 am Austin Einter wrote: > > Thanks Nancy. > > Do you mean that in my code I should not put the value for "cid". That > > means $lastid (in red) should be removed. > > > > > > *$lastid = 0; > > for($delta = 0; $delta < $all_companies; $delta++) > > { > > $lastid = db_last_insert_id(rs_companies, cid) + 1; > > db_query( > > 'INSERT INTO {rs_companies} ( cid, uid, prevcompany, joindate, > > releasedate) ' > > ."VALUES (%d, '%d', '%s', '%d', '%d')", > > $lastid, * > > *$user->uid* > > > > > > Regards > > Austin > > > > On Mon, Mar 28, 2011 at 4:20 PM, nan wich <nan_wich(a)bellsouth.net> > wrote: > > > You don't need to provide the value for an auto increment field. > > > > > > "Db_last_insert_id()" is how you get the value *after* the insert, if > you > > > need it at all. > > > > > > > > > *Nancy* > > > > > > > > > > > > Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. > > > King, Jr. > > > > > > ------------------------------ > > > *From:* Austin Einter > > > > > > I have a table, where 'cid' field is of type "serial". > > > > > > *$lastid = 0; > > > > > > for($delta = 0; $delta < $all_companies; $delta++) > > > { > > > > > > $lastid = db_last_insert_id(rs_companies, cid) + 1; > > > > > > db_query( > > > > > > 'INSERT INTO {rs_companies} ( cid, uid, prevcompany, joindate, > > > > > > releasedate) ' > > > > > > ."VALUES (%d, '%d', '%s', '%d', '%d')", > > > > > > $lastid, * >

1 0