Knowledgebase
View categorized listing of all common frequently asked questions.
Video Tutorials (jReviews 2.0)
Create a Movie & TV Show review website.
Customize the jReviews themes.
Review user profiles with the Everywhere addon.
Forum
Community forum
Submit a Ticket
Use your client area email to access the ticket system.
Downloads
Guides, modules and more...
Reviews Ahoy!

Extensions we recommend

CSV Import for Joomla and jReviews
 
Welcome, Guest. Please login or register.
Did you miss your activation email?
December 01, 2008, 08:59:40 PM
 21661 Posts in 4948 Topics by 2838 Members
Latest Member: davidkan
News: Do not post any jReviews files or large amounts of code in the forums please. Only template files and code are allowed.
 
jReviews Support Forum  |  Extensions  |  CSV Import for Joomla and JReviews  |  No records being imported - Trial CSV « previous next »
Pages: [1] 2
Author Topic: No records being imported - Trial CSV  (Read 3015 times)
DingoBlue
Newbie
*
Offline Offline

Posts: 17
« on: March 03, 2008, 09:10:57 PM »
I have been trialling the import CSV component but with no luck,  I get the following for each of the 5 records I try:

Line   2 Line   Table 'skalsydn_skalsydney2010.jos_jreviews_content' doesn't exist SQL=Insert Into jos_jreviews_content(`contentid`) Values('32')

I am running JOOMLA 1.5.1 with legacy on.  I loaded the IonCube version.  I am not running jReviews.

Can you indicate where I might have gone wrong?

Regards
Logged
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8592
« Reply #1 on: March 03, 2008, 10:31:58 PM »
Sorry about that. Try this version and let me know the results.
« Last Edit: March 04, 2008, 06:23:03 AM by Alejandro » Logged
Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
DingoBlue
Newbie
*
Offline Offline

Posts: 17
« Reply #2 on: March 04, 2008, 12:32:34 AM »
Perfect - thank you.

Is the "real" ($$) version OK to use now?

Regards
Logged
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8592
« Reply #3 on: March 04, 2008, 06:24:04 AM »
Thanks for letting me know. Yes, both the trial and full versions have now been updated.
Logged
Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
owaho
Newbie
*
Offline Offline

Posts: 5
« Reply #4 on: March 19, 2008, 05:45:49 PM »
Quote from: Alejandro on March 04, 2008, 06:24:04 AM
Thanks for letting me know. Yes, both the trial and full versions have now been updated.

I'm having the same problem, when i try to import records, I get

Line 2   Table \'euturpec_register.jos_jreviews_content\' doesn\'t exist SQL=Insert Into jos_jreviews_content(`contentid`) Values(\'57\')
Logged
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8592
« Reply #5 on: March 20, 2008, 01:57:01 PM »
I have uploaded several new releases since this problem was first reported. Go to the components installer and check if you have version 1.0.6 or later, otherwise download the newer version and reinstall.
Logged
Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
owaho
Newbie
*
Offline Offline

Posts: 5
« Reply #6 on: March 21, 2008, 12:16:46 PM »
I have 1.0.6 installed. I tried uploading the csv file on the demo you have set up, and everything worked fine. It's a simple csv, title, section ID, category ID, with only one row of data.
Logged
owaho
Newbie
*
Offline Offline

Posts: 5
« Reply #7 on: March 21, 2008, 01:35:22 PM »
I went ahead and purchased the component since I have good faith in my previous experiences. Unfortunately, I'm still getting the same error even with the purchased component.

I'm running Joomla 1.0.12, jreviews 1.2.10
Logged
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8592
« Reply #8 on: March 21, 2008, 05:43:49 PM »
I promise I'll look into this, but you'll need to wait until next week when I get back from holidays. If you install jReviews on the site where you are trying to use CSV Import, the problem should be solved, but of course this isn't the ideal solution.
Logged
Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8592
« Reply #9 on: March 23, 2008, 03:52:24 PM »
I have checked the code in the latest version and it has the changes to prevent this error. The only situation in which the error would occur is if the component/com_jreviews folder exists, but the jreviews tables are not there. What exactly is the situation re: jReviews in the site where you are testing this? Has it ever been installed? Is it installed right now?
Logged
Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
Sall1
Newbie
*
Offline Offline

Posts: 9
« Reply #10 on: March 29, 2008, 02:40:41 AM »
Hello Alejandro, I've been having the same problem when trying to import my CSVs
This is the error code I get:

0 new content items were created successfully.
1   not imported (check errors below)
Line   2    Line   Table \'karsi02_sarki3.jos_jreviews_content\' doesn\'t exist SQL=Insert Into jos_jreviews_content(`contentid`) Values(\'648\')


I got the paid version but it stills gives me the same error
I'm using joomla 1.0.15, jreviews 12.0.10 and CSV Import 1.0.7
Logged
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8592
« Reply #11 on: March 29, 2008, 09:07:58 AM »
Do you have jReviews installed?

Please submit a ticket with super admin access, ftp access and an example csv I can use and I'll fix this for you and update the component.
Logged
Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8592
« Reply #12 on: March 29, 2008, 07:35:06 PM »
Ok, I have narrowed down this problem to installations not using the standard jos_ database table prefix. If you run into this issue, search in admin.csv_import.php for this line:

Code:
$err = insertObject("jos_jreviews_content",$arrJreviewData);

And change to:

Code:
$err = insertObject("#__jreviews_content",$arrJreviewData);

I'll update this in the next release.
Logged
Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
Sall1
Newbie
*
Offline Offline

Posts: 9
« Reply #13 on: March 31, 2008, 12:43:43 PM »
Thanks Alejandro, you're great!
Logged
owaho
Newbie
*
Offline Offline

Posts: 5
« Reply #14 on: May 07, 2008, 06:07:13 PM »
Alejandro,

Sorry for the long delay in replying! Class work started building up.

I am still experiencing the same problem. I have JReviews installed and version 1.0.7 of csv import.

For some reason when I FTP or use my hosts file browser to com_csv_import it shows no content, so I can't make the change you suggested.

Is there a way I can send you more info to setup a user account for you to check the stuff out on my site?

Thanks!
Logged
Pages: [1] 2
« previous next »
    Jump to:  


    Powered by MySQL Powered by PHP Powered by SMF 1.1.7 | SMF © 2006-2008, Simple Machines LLC
    Joomla Bridge by JoomlaHacks.com     		Valid XHTML 1.0! Valid CSS!